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
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
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.