Hi,
Can I post data to a mysql database via a function node? I have a limited Node-RED in my device and I can't install mysql node.
Thank you,
Roger.
Hi,
Can I post data to a mysql database via a function node? I have a limited Node-RED in my device and I can't install mysql node.
Thank you,
Roger.
You could use the underlying mysql nodejs module (but you would have to install that), or you could do it using an exec node to execute an OS command to do it. It would be much easier with the mysql node though. Why can't you install it?
You could use tcp or mqtt to talk to another device. Then have that device which can load the SQL node run the query. You can probably install node red on your sql server or MySQL server. This could also host your mqtt broker.
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.