Send variables from Node Red to MySql

[Folke Haglund]

Hello,

I would like to send the value of 3 variables, Energ1, Energy2 and Energy3, which are in a function node to columns KWh1, KWh2 and KWh3 in Mysql.

I have tried the "INSERT INTO ...", but I can't  get it to work.

Is there anyone who can help me?

Best Regards

Folke

[Paul Reed]

INSERT INTO `MyDatabase` (`KWh1`,`KWh2`,`KWh3`) VALUES (" + Energy1 + "," + Energy2 + "," + Energy3 + ")

Paul

[Folke Haglund]

I have tried that, but it does not work.

// Folke

[Paul Reed]

Just saying it doesn't work, is not really helpful!

What have you tried, are there any error messages/log entries, have you set up your MYSQL credentials correctly, what does the relevant part of your flow look like ?

Paul

[steve rickus]

If I recall correctly, that insert statement needs to be in msg.topic, not msg.payload... the output payload then returns the matching results.

[Folke Haglund]

I have a solution and it looks like this.

msg.topic = "INSERT INTO table (Id, Time, KWh1, KWh2, KWh3, Totalt) VALUES (id, CURTIME(), " + CurrentEnergi1 + ", " + CurrentEnergi2 + ", " + CurrentEnergi3 + ", " + TotalEnergi +")";

//Folke

[Cristiano Nunes]

var sql = [];

var outputs = [];

sql = "INSERT INTO table (Id, Time, KWh1, KWh2, KWh3, Totalt) VALUES (id, CURTIME(), " + CurrentEnergi1 + ", " + CurrentEnergi2 + ", " + CurrentEnergi3 + ", " + TotalEnergi +")";

outputs.push({topic:sql}); 

return [outputs];

hello, try this code.

[Folke Haglund]

It works too.

Thank you.

//Folke