I have 2 input from mqtt and i want to split the data/value into 2 column in mysql. For example i want to separate the value of temperature as 29.70 and humidity as 84.00. But based on my result the 2 column shown the same data/value.
This is my code at function node:
Temperature = msg.payload
Humidity = msg.payload
msg.topic = "INSERT INTO dht11 (Temperature,Humidity)"+" VALUES ('"+ Temperature +"','"+ Humidity +"')";