Logging and JSON backup to MySQL

[Steve-Mcl]

@OriolFM

What I thought first is to just queue the JSON string, but then I need to replace all the quotes in the JSON by ("), or it will have parse errors when I pass it onto the MYSQL node, right

There are a couple of ways around this but the best solution is to use a prepared query & pass the values in the payload instead of building a string query.

Look at the readme for the mySQL node - there is a section on preparing queries.

Lastly, you might want to read this...

"How To Work with JSON in MySQL | DigitalOcean" How To Work with JSON in MySQL | DigitalOcean