Advanced Node-RED & MySQL tips and techniques

[@utsmanjunath]

One of the best video i saw for Node-red Mysql combination !

[@Opto22]

Thank you so much Manjunath!!

[@agler_]

isn't concatenating the SQL statements like this susceptible to SQL injection attacks?

[@FidelAlexanderHernándezG]

Brother.... this is enlightening. You're a boss. Thank you for sharing this!

[@asifsiddique6646]

can you please give the link of the previous video. Couldn't find it

[@wick_bourne]

Yes, i was also going to ask same thing

[@Opto22]

here is the link to the Intro to MySQL Node-RED Nodes video: kzbin.info/www/bejne/oXrcnYmlbcurj7s

[@wick_bourne]

@@Opto22 heyy, its uploaded just 40 minute ago. That's cheating. Fun aside, you are the Only one i can count on for node-red. Best of 🍀

[@Opto22]

@@wick_bourne Sorry about that Shubham, Somehow this video didn't get posted on our KZbin Channel. For more free Node-RED videos please check out our free training site: training.opto22.com/ Also, be sure to join the community at: forums.opto22.com/ And our developer community at: developer.opto22.com/ And find more videos at: www.opto22.com/support/videos

[@printsmartiot]

hi thanks for u sharing this information . can u please explan how to set "and" "or" "not" in node-red with 2 input .

[@krisnalingga]

How to make select date & time & download button on dashboard? I want to download data in mysql, from node red dashboard.

[@balajovidiu9699]

Hi there. Thanks for the video and information. Do you have a video where you create multiple instances of node-red for multiple projects on same server at once? :)

[@Opto22]

kzbin.info/www/bejne/oXrcnYmlbcurj7s

[@kevinargudin2318]

Hi, Thanks for the video. I was wondering if you had an opinion on data validation? By that in this example for the price parameter should we use a more comprehensive function within your convert to string OR is it better to catch the fail on conversion to a float? In either case we would need to notify the user that there is a problem with what they entered. We could either wait until they save (use this event to check) or once they leave the price entry field, but I'm not quite sure how to get that correct.

[@هبةمهديصالحالموسوي]

Great video . i need help please can you help me how to do data classification for diagnosis of patients using red nod ?

[@Kiyura24]

Hi, that is very useful. I have a problem with my project, how to insert data in multiple table in 1 database using function in node-red?

[@Opto22]

Thanks for watching! The first possibility that comes to mind would be to the function `node.send()` to return multiple objects; one for each table, for example. nodered.org documentation has more info on how that function can be used.

[@damianvalle5634]

Thank you for sharing this videos, they are very useful!

[@Opto22]

You're very welcome!

[@virtumind]

previous video link ?

[@Opto22]

Here you go: kzbin.info/www/bejne/mYCbgqOvitN4rck

[@aznableredking2656]

amazing video this video help me a lot to build my project thank you the instructor very much

[@Opto22]

Great to hear!

[@nikitamane-se3tx]

how to ues php code in node red and fatch mysql database

[@groovheads]

I'm not sure PHP would be the best tool to use here. Javascript would be the much better way to work in Node-RED with MySQL. Most MySQL actions can be done in Node-RED with no extra outside code required.

[@nikitamane-se3tx]

please help me , i need Dynamically add led_ui node in node red dashboard

[@nikitamane-se3tx]

@@groovheads give a javascript code please

[@granxavi]

It allows injection attacks, be careful. I am searching ways to disable injection attacks but I don't find any with sql and node-red. If someone knows how, please tell me.

[@faisalsaddique3323]

Thank you so much!

[@Opto22]

No worries!

[@roquiamuzaffari4213]

Sir i am unable to insert my data to mysql database.. Plz make a video to do insert into mysql.. I have seen your video its awesome.. Plz help me.. Thanks in advance..

[@ardianbara2534]

So easy bro 😊

[@tasosstr5774]

The audio are ok something wrong are in your speakers. Very good job 👌👍 well done ✅ keep the good job !!!

[@Opto22]

Ok, thank you

[@xbbast]

No sound :(

[@Opto22]

There is definitely sound - try refreshing the page or adjusting your audio settings. Thanks for watching!

[@xbbast]

@@Opto22 Yes indeed. Now I have sound. This is odd...

[@Opto22]

Phew! Glad to hear it. Thanks for watching!!

[@wick_bourne]

can you please give the link of the previous video. Couldn't find it

[@Opto22]

Here is the link to the Intro to the MySQL Node-RED Node video: kzbin.info/www/bejne/oXrcnYmlbcurj7s