# MySQL Node Odd ER\_PARSE\_ERROR 5 out of 38,000 records

**URL:** <https://discourse.nodered.org/t/mysql-node-odd-er-parse-error-5-out-of-38-000-records/52377>\
**Category:** General\
**Tags:** database\
**Created:** [18 October 2021 20:17 UTC](https://discourse.nodered.org/t/mysql-node-odd-er-parse-error-5-out-of-38-000-records/52377 "2021-10-18T20:17:23Z")\
**Posts on this page:** 1\
**Showing post:** 10

<div class="post-metadata">

**Author:** ![HarryPottar](https://avatars.discourse-cdn.com/v4/letter/h/bb73d2/32.png) [@HarryPottar](https://discourse.nodered.org/u/HarryPottar)\
**Post date:** [18 October 2021 21:02 UTC](https://discourse.nodered.org/t/mysql-node-odd-er-parse-error-5-out-of-38-000-records/52377/10 "2021-10-18T21:02:30Z")

</div>

They were single quotes

fyi. loading mysql node globally to get access to mysql escape.

const mysql = global.get("mysql");

mysql.esacpe adds the single quotes for you.

`VALUES (" + mysql.escape(data.partnumber) + "," + mysql.escape(data.name) + "`

Produces

```auto
VALUES ('USA-BLUEKIT','Scott Drake Bluetooth&reg; Interface for Custom Autosound CD Controller Radios','Bluetooth? Interface for Custom Autosound CD Controller Radios','2021-05-05 09:03:38')

```

Note the single quotes added.

Harry

edit  
Oh you meant in the js  
`VALUES (' + mysql.escape(data.partnumber) + ',' + mysql.escape(data.name) + '`

---

_[View the full topic](https://discourse.nodered.org/t/mysql-node-odd-er-parse-error-5-out-of-38-000-records/52377)._