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

General
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

image
image.png1920×1080 259 KB

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?

7

Where can I find this post which propably will have the answer I need?

8

Seeing that this thread is a year old, please opens new thread with your issue.

Meanwhile I’ll close this thread