How to Insert Table Values Into MS SQL and MySQL as Separate Records

Node-RED
45

In your SQL node - just put in {{{payload}}} - you already built the insert statement in the function block - what the SQL server is seeing is this:

insert into MyTable ([Column1], [Column2]) values insert into MyTable([Column1], [Column2]) values (0,0), …

2 Likes
46

Now it works perfectly.
Thank you so much philip for your explanation and support!

1 Like