Dear All, We are trying to insert some data to MySQL - Table but data not adding. Any issue with the following configuration since data logging is not happening. Table showing no records. [image]

I am using Node-Red-Node-Mysql node Exporting the flow for your reference. [{"id":"47169a4b.e85434","type":"tab","label":"Flow 4","disabled":false,"info":""},{"id":"71460f4e.15746","type":"function","z":"47169a4b.e85434","name":"","func":"//var SLNo = 1;\n//msg.topic = \"insert into Test values (?…

sorry no Luck. "Error: ER_PARSE_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 '?,?,?,?,?,Now(),?)' at line 1"

Feed what is going into the sql node into a Debug node set to show Complete message and then show both what is going into the sql node and what is coming out.

well, I am at a loss. Perhaps you are using an old version? You can drop back to unsafe dynamic SQL var data = msg.payload; msg.topic = `insert into tblDB1_Test (Word0,Word2,Word4,Word6,Word8,LastUpdatedOn,LastUpdatedBy) values (${data.Word0},${data.Word2},${data.Word4},${data.Wor…

i am using latest version of MySQL. MariaDB [(none)]> SELECT VERSION(); +---------------------------+ | VERSION() | +---------------------------+ | 10.3.27-MariaDB-0+deb10u1 | +---------------------------+ Following are the result. WARN: //msg.topic = "insert into tblDB1_Te…

you did something wrong. that should get changed to ... insert into tblDB1_Test (Word0,Word2,Word4,Word6,Word8,LastUpdatedOn,LastUpdatedBy) values (1,2,3,4,5,Now(),'Admin'); what nodejs version are you using?

i tried using both. msg.topic = "insert into tblDB1_Test (SLNo,Word0,Word2,Word4,Word6,Word8,LastUpdatedOn,LastUpdatedBy) values (SLNo,{data.Word0},{data.Word2},{data.Word4},{data.Word6},${data.Word8},Now(),'Admin')"; msg.topic = "insert into tblDB1_Test (Word0,Word2,Word4,Word6,Word8,LastUpda…

Thats not what I told you to do. you have changed the ` backticks to double quotes. i said... var data = msg.payload; msg.topic = `insert into tblDB1_Test (Word0,Word2,Word4,Word6,Word8,LastUpdatedOn,LastUpdatedBy) values (${data.Word0},${data.Word2},${data.Word4},${data.Word6}…

[image] Steve-Mcl: insert into tblDB1_Test (Word0,Word2,Word4,Word6,Word8,LastUpdatedOn,LastUpdatedBy) values (1,2,3,4,5,Now(),'Admin'); even i tried with this...

[image] reachrao01: [image] Steve-Mcl: > insert into tblDB1_Test (Word0,Word2,Word4,Word6,Word8,LastUpdatedOn,LastUpdatedBy) values (1,2,3,4,5,Now(),'Admin'); > ``` even i tried with this... Well it works for me. It is a valid SQL statement I did this... create datab…

MySQL Data Logging Issue

General

reachrao01 10 March 2021 12:56 24

Sorry, Yesterday i could not respond to your post because per day i have limit of 20 post
Issue has been fixed and it is related to SQL Data Type mapping.

Thank you so much for your support

Topic		Replies	Views
Read from mysql db Dashboard	54	17580	23 December 2018
Error: ER_BAD_FIELD_ERROR: Unknown column 'RND0508A03A' in 'field list' General database , function-node	22	1836	31 May 2022
How to insert in a database? General database	48	2472	19 October 2022
Mysql data logging General function-node	4	171	25 May 2023
Maximum Insert Speed for mySQL through network? General	33	1985	4 September 2019

MySQL Data Logging Issue

Related topics