A Node-RED node to read and write to a MySQL database.
Run the following command in your Node-RED user directory - typically ~/.node-red
npm install node-red-node-mysql
Allows basic access to a MySQL database.
This node uses the query operation against the configured database. This does allow both INSERTS and DELETES.
Using legacy method where queries are set in msg.topic allows SQL injection... so be careful out there...
###Direct Inserted Queries
With SQL queries that are directly added on the node, variables are escaped.
SQL queries can use mustache style variable insertion. If our msg.payload has a property key, we would write a query as following:
SELECT *
FROM table
WHERE column = {{key}};
For more escaped input information, you can refer to the documentation for mysqljs/mysql.
###Results
Typically the returned payload will be an array of the result rows.
If nothing is found for the key then null is returned,
###Misc.
The reconnect timeout in milliseconds can be changed by adding a line to settings.js
mysqlReconnectTime: 30000,
###Legacy
msg.topic must hold the query for the database, and the result is returned in msg.payload.
msg.payload can contain an array of values to bind to the topic.