How to insert multiple data into the correct field of mysql database

#1

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

#2

Did you try a search of the forum to see if others have had similar questions? (hint hint)

#3

i checked but i didn't get through

#4

When you say "i checked but i didn't get through" what do you mean?

#5

Someone was doing something similar to what i was doing. He got a suggestion how to fix it put he didn't respond after the suggestion so i dont know if the problem was solved or not...

#6

did you try the suggesstion he got?