Connect Node-Red to SQL Database

[@quoit99training83]

What about connecting to Microsoft SQL or MSSQL? I tried MSSQL plus node but keep getting error

[@jean-rem]

Hello,
Thanks for the clear tutorial.
Could you imagine to do (nearly) the same tutorial but using Excel database spreadsheet to store some data ?
Regards
Jean-Rem
👍

[@rohitpujari4059]

Please upload all tutorials as soon as possible. Thank you.

[@milesg7979]

great video. i still got some trouble because im trying to get flow variables into the database. could u help me on that?

[@ruwindustries]

check out this video: th-cam.com/video/od8Agg9x6sw/w-d-xo.html

[@catorlife]

when the mysql node returns error, how to get that error text?

[@ruwindustries]

You can use the catch node for that

[@rohitpujari4059]

Thank you for this video. Can you please do a simple CRUD application using MySQL queries. I am trying to do the same but facing some errors.

[@ruwindustries]

Do you have problems updating the data? I have already addressed all the other Operations. Or are you looking for a User Interface?

[@rohitpujari4059]

@@ruwindustries I am trying to do user CRUD operations. But while inserting new user data to the table I am getting a syntax error in Node-RED. I know that I am making some mistakes but not getting those mistakes.
Also at the time of getting only one user's data, on the basis of email id, same error I am getting.

[@ruwindustries]

@rohitpujari4059 If you want you could send me your current SQL query and the error message to the following email. I can try to fix it for you.
[e-mail]

[@rohitpujari4059]

Okay

[@wozza2942]

Good video, but please kill the horrible music. It's unnecessary and distracting.

[@topfundus1093]

danke, leider furchtbare Musik