Hello, i am trying to insert multiple data into a mysql database but i am unable to insert them into the correct field here is my flow diagram
here is how i've written my node function...
msg.topic="INSERT Into fire_contents (Temperature1) values(?)"; msg.payload=[msg.payload]; return msg;
(Temperature1,Temp2) and (?,?) would allow me to insert data into two columns
but i dont understand how to insert the data into the correct columns or order