javascript – Error on node-red when I try to insert values to MySQL

admin

Why I get this error:

“Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ”table-1453′ (apellido,temp1PromC,temp2PromC,temp1MinC,temp1MaxC,fechaHora) V…’ at line 1″

this is my query

msg.topic = “INSERT INTO ‘table-1453’ (apellido,temp1PromC,temp2PromC,temp1MinC,temp1MaxC,fechaHora) ” + “VALUES (?,?,?,?,?,?)”
msg.payload = [msg.payload.apellido,
msg.payload.temp1PromC,
msg.payload.temp2PromC,
msg.payload.temp1MinC,
msg.payload.temp1MaxC,
msg.payload.fechaHora]
return msg;

I’ve been trying to know how can I solve this, my table on MySQL needs to be named 1453, maybe thats an error?

Read more here: Source link