Ideally yes, but I have not been able to figure out how to use them in node-red when chaining/making one long sql call as in this example. Some of the csv's we import have 750K rows and makes it more efficient to make one call rather than a series of many.
I'm always willing to learn if someone can demonstrate how to do the above with prepared statements.
One of the reasons I import msql node js is so that I can escape the values safely.
harry
Copyright OpenJS Foundation and Node-RED contributors. All rights reserved. The OpenJS Foundation has registered trademarks and uses trademarks. For a list of trademarks of the OpenJS Foundation, please see our Trademark Policy and Trademark List. Trademarks and logos not indicated on the list of OpenJS Foundation trademarks are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.
The OpenJS Foundation | Terms of Use | Privacy Policy | OpenJS Foundation Bylaws | Trademark Policy | Trademark List | Cookie Policy