Re: Error: ER_EMPTY_QUERY: Query was empty

[Rui Quelhas]

Hi Thijmen,

this forum is for the MySQL X DevAPI Connector for Node.js aka as mysql-connector-nodejs (https://github.com/mysql/mysql-connector-nodejs) or mysql/@xdevapi (https://www.npmjs.com/package/@mysql/xdevapi).

Seems like you are using the mysqljs/mysql driver (https://github.com/mysqljs/mysql), which is not an official MySQL product. I would encourage you to use the project issue tracker (https://github.com/mysqljs/mysql/issues) to report the issue understand what the root cause might be.

In any case, looking at your code, conceptually, the "INSERT" statement looks ok. There are no schema violations, so I'm assuming everything is fine from that standpoint.

But without a proper character encoding and formatting, it's not easier to understand exactly what the issue might be, because I'm not sure what is supposed to be verbatim or not.

Hope it helps


Cheers