# ER\_PARSE\_ERROR in mysql node

**URL:** <https://discourse.nodered.org/t/er-parse-error-in-mysql-node/54099>\
**Category:** General\
**Created:** [22 November 2021 11:07 UTC](https://discourse.nodered.org/t/er-parse-error-in-mysql-node/54099 "2021-11-22T11:07:25Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![sahsha](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/sahsha/32/43845_2.png) [@sahsha](https://discourse.nodered.org/u/sahsha)\
**Post date:** [22 November 2021 11:07 UTC](https://discourse.nodered.org/t/er-parse-error-in-mysql-node/54099/1 "2021-11-22T11:07:26Z")

</div>

Need help to insert query using mysql node. I'm getting error:

> 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 'DELIMITER ;;  
> CREATE TRIGGER t BEFORE INSERT ON gdc  
> FOR EACH ROW BEGIN  
> SET ...' at line 1

But when inserted using "phpmyadmin", shows no error.

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/b/7/b7a59b2b1fd943c2c2769a7dcf5f68319ab54941.png)

What am I doing wrong?

```auto
[{"id":"aadf71f9.37505","type":"mysql","z":"50a610c6.08a6a","mydb":"a844720c.608d6","name":"","x":1230,"y":400,"wires":[["2c15ffc.d6401"]]},{"id":"2c15ffc.d6401","type":"debug","z":"50a610c6.08a6a","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":1390,"y":400,"wires":[]},{"id":"ae5aa79c.41a748","type":"template","z":"50a610c6.08a6a","name":"","field":"topic","fieldType":"msg","format":"handlebars","syntax":"mustache","template":"DELIMITER ;; \nCREATE TRIGGER t BEFORE INSERT ON gdc \nFOR EACH ROW BEGIN \nSET NEW.top_die_temp_gdc1 = NEW.top_die_temp_gdc1 / 10; \nSET NEW.bottom_die_temp_gdc1 = NEW.bottom_die_temp_gdc1 / 10; \nSET NEW.top_die_temp_gdc2 = NEW.top_die_temp_gdc2 / 10; \nSET NEW.bottom_die_temp_gdc2 = NEW.bottom_die_temp_gdc2 / 10; \nSET NEW.top_die_temp_gdc3 = NEW.top_die_temp_gdc3 / 10; \nSET NEW.bottom_die_temp_gdc3 = NEW.bottom_die_temp_gdc3 / 10; \nSET NEW.top_die_temp_gdc4 = NEW.top_die_temp_gdc4 / 10; \nSET NEW.bottom_die_temp_gdc4 = NEW.bottom_die_temp_gdc4 / 10; \nSET NEW.top_die_temp_gdc5 = NEW.top_die_temp_gdc5 / 10; \nSET NEW.bottom_die_temp_gdc5 = NEW.bottom_die_temp_gdc5 / 10; \nEND;; \nDELIMITER ;\nINSERT INTO `gdc`(`date`, `time`, `water_temp`, `ci_temp`,`hydraulic_temp`, `top_die_temp_gdc1`, `side_die_temp_gdc1`, `bottom_die_temp_gdc1`,`top_die_temp_gdc2`, `side_die_temp_gdc2`, `bottom_die_temp_gdc2`,`top_die_temp_gdc3`, `side_die_temp_gdc3`, `bottom_die_temp_gdc3`,`top_die_temp_gdc4`, `side_die_temp_gdc4`, `bottom_die_temp_gdc4`,`top_die_temp_gdc5`, `side_die_temp_gdc5`, `bottom_die_temp_gdc5`) \nVALUES ('2021-11-22','14:34','25','29','392','334','33','339','331','37','348','344','42','375','350','34','344','346','33','344')","output":"str","x":1080,"y":400,"wires":[["aadf71f9.37505"]]},{"id":"ffcbb284.e67e6","type":"inject","z":"50a610c6.08a6a","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":920,"y":400,"wires":[["ae5aa79c.41a748"]]},{"id":"a844720c.608d6","type":"MySQLdatabase","name":"","host":"127.0.0.1","port":"3306","db":"mts","tz":"","charset":""}]

```

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [22 November 2021 11:39 UTC](https://discourse.nodered.org/t/er-parse-error-in-mysql-node/54099/2 "2021-11-22T11:39:37Z")

</div>

I don't think the sql node copes with mulitple statements like that.

---

<div class="post-metadata">

**Author:** ![sahsha](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/sahsha/32/43845_2.png) [@sahsha](https://discourse.nodered.org/u/sahsha)\
**Post date:** [22 November 2021 12:10 UTC](https://discourse.nodered.org/t/er-parse-error-in-mysql-node/54099/3 "2021-11-22T12:10:51Z")

</div>

😕. trying a different route using a function node by following below post.

> [Using mysql node but no joy with insert query - #3 by Nodi.Rubrum](https://discourse.nodered.org/t/using-mysql-node-but-no-joy-with-insert-query/29234/3)

---

<div class="post-metadata">

**Author:** ![sahsha](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/sahsha/32/43845_2.png) [@sahsha](https://discourse.nodered.org/u/sahsha)\
**Post date:** [22 November 2021 12:53 UTC](https://discourse.nodered.org/t/er-parse-error-in-mysql-node/54099/4 "2021-11-22T12:53:35Z")

</div>

solved. now don't need to generate trigger in mysql querry.

```auto
[{"id":"86954fb0.83bda","type":"function","z":"50a610c6.08a6a","g":"a4a9feca.8bad3","name":"GDC - 1, 2, 3, 4, 5","func":"msg.topic = \"INSERT INTO `gdc`(`date`,`time`,`water_temp`,`ci_temp`,`hydraulic_temp`,`top_die_temp_gdc1`,`side_die_temp_gdc1`,`bottom_die_temp_gdc1`,`top_die_temp_gdc2`,`side_die_temp_gdc2`,`bottom_die_temp_gdc2`,`top_die_temp_gdc3`,`side_die_temp_gdc3`,`bottom_die_temp_gdc3`,`top_die_temp_gdc4`,`side_die_temp_gdc4`,`bottom_die_temp_gdc4`,`top_die_temp_gdc5`,`side_die_temp_gdc5`,`bottom_die_temp_gdc5`)\"+\n\"VALUES(\"\n + \"'\" + msg.myymd + \"',\"\n + \"'\" + msg.mytime + \"',\"\n + \"'\" + msg.payload.D7030 + \"',\" //water_temp\n + \"'\" + msg.payload.D7034 + \"',\" //ci_temp\n + \"'\" + msg.payload.D7032 + \"',\" //hydraulic_temp\n + \"'\" + msg.payload.D7000/10 + \"',\" //top_die_temp_gdc1\n + \"'\" + msg.payload.D7002 + \"',\" //side_die_temp_gdc1\n + \"'\" + msg.payload.D7004/10 + \"',\" //bottom_die_temp_gdc1\n + \"'\" + msg.payload.D7006/10 + \"',\" //top_die_temp_gdc2\n + \"'\" + msg.payload.D7008 + \"',\" //side_die_temp_gdc2\n + \"'\" + msg.payload.D7010/10 + \"',\" //bottom_die_temp_gdc2\n + \"'\" + msg.payload.D7012/10 + \"',\" //top_die_temp_gdc3\n + \"'\" + msg.payload.D7014 + \"',\" //side_die_temp_gdc3\n + \"'\" + msg.payload.D7016/10 + \"',\" //bottom_die_temp_gdc3\n + \"'\" + msg.payload.D7018/10 + \"',\" //top_die_temp_gdc4\n + \"'\" + msg.payload.D7020 + \"',\" //side_die_temp_gdc4\n + \"'\" + msg.payload.D7022/10 + \"',\" //bottom_die_temp_gdc4\n + \"'\" + msg.payload.D7024/10 + \"',\" //top_die_temp_gdc5\n + \"'\" + msg.payload.D7026 + \"',\" //side_die_temp_gdc5\n + \"'\" + msg.payload.D7028/10 + \"')\"; //bottom_die_temp_gdc5\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":1210,"y":100,"wires":[["12d51ed2.7ac181"]]}]

```

---

<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:** [21 January 2022 12:54 UTC](https://discourse.nodered.org/t/er-parse-error-in-mysql-node/54099/5 "2022-01-21T12:54:31Z")

</div>

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