# NODE RED MySql parse error

**URL:** <https://discourse.nodered.org/t/node-red-mysql-parse-error/30203>\
**Category:** General\
**Created:** [16 July 2020 11:03 UTC](https://discourse.nodered.org/t/node-red-mysql-parse-error/30203 "2020-07-16T11:03:05Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![shipra](https://avatars.discourse-cdn.com/v4/letter/s/71c47a/32.png) [@shipra](https://discourse.nodered.org/u/shipra)\
**Post date:** [16 July 2020 11:03 UTC](https://discourse.nodered.org/t/node-red-mysql-parse-error/30203/1 "2020-07-16T11:03:05Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![dynamicdave](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/dynamicdave/32/96_2.png) [@dynamicdave](https://discourse.nodered.org/u/dynamicdave)\
**Post date:** [16 July 2020 11:38 UTC](https://discourse.nodered.org/t/node-red-mysql-parse-error/30203/2 "2020-07-16T11:38:12Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![zenofmud](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/zenofmud/32/316_2.png) [@zenofmud](https://discourse.nodered.org/u/zenofmud)\
**Post date:** [16 July 2020 12:22 UTC](https://discourse.nodered.org/t/node-red-mysql-parse-error/30203/3 "2020-07-16T12:22:17Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [14 September 2020 12:22 UTC](https://discourse.nodered.org/t/node-red-mysql-parse-error/30203/4 "2020-09-14T12:22:26Z")

</div>

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