NODE RED MySql parse error

Error: ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM * rfid1 WHERE rfidno='E1234561'' at line 1"

getting this error .please help

Going to need more information from you as to how Node-RED fits into this question.

If you have a Node-RED flow, it would be helpful if you published it.

How are you building the sql statement?

stick a debug node (set to display the complete msg object) on the node that feds the MySQL node and the output of the MySQL node and show the results - make sure to open all the triangles in the debug so all data shows.

and as @dynamicdave said, a copy of your flow will b helpful

1 Like

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.