Это видео недоступно.
Сожалеем об этом.
Advanced Node-RED & MySQL tips and techniques
HTML-код
- Опубликовано: 18 авг 2024
- In this video Opto 22's Terry Orchard takes a deep dive into the MySQL database nodes to insert data into and select data from a MariaDB server. Terry shows you how two different methods are used to insert: first using locally saved context variables within Node-RED, and then building up similar data in a single message object. Finally we select the data back into the flow and display it in a Node-RED dashboard table that is running on a groov RIO.
Terry uses a groov RIO as a means of gathering physical I/O inputs and outputs. Opto 22's groov RIO is edge I/O for the IIoT: standalone industrial I/O that collects and securely publishes data from field to cloud. www.opto22.com...
Watch the intro to the MySQL Node-RED nodes video:
• Basic Intro to MySQL N...
Chapters:
0:00 Intro
1:50 Explore MySQL from Node-RED
4:27 Gather Data from Node-RED Dashboard
18:00 Creating an Insert Statement
21:32 Testing an Insert Statement
26:26 Gather Data from Physical Inputs
43:33 Display MySQL Data with the Table Node
Learn more at:
Opto 22 forums: forums.opto22....
groov IO node video: • Setting Up groov IO No...
groov IO nodes: flows.nodered....
Node-RED dashboard UI introduction video: • Tutorial: Basic Node-R...
Node-RED dashboard UI nodes: flows.nodered....
Node-RED dashboard UI table node: flows.nodered....
More Info
groov RIO: www.opto22.com...
developer.opto2...
www.opto22.com/
forums.opto22....
For more free training checkout:
training.opto2...
All Opto 22 products are designed, manufactured, and supported in the U.S.A. from our Temecula, California headquarters and factory.
#nodered #tutorial
One of the best video i saw for Node-red Mysql combination !
Thank you so much Manjunath!!
Brother.... this is enlightening. You're a boss. Thank you for sharing this!
isn't concatenating the SQL statements like this susceptible to SQL injection attacks?
amazing video this video help me a lot to build my project thank you the instructor very much
Great to hear!
can you please give the link of the previous video. Couldn't find it
Yes, i was also going to ask same thing
here is the link to the Intro to MySQL Node-RED Nodes video:
ruclips.net/video/kIylVo8fxYY/видео.html
@@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 🍀
@@wick_bourne Sorry about that Shubham, Somehow this video didn't get posted on our RUclips 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
hi thanks for u sharing this information . can u please explan how to set "and" "or" "not" in node-red with 2 input .
Thank you for sharing this videos, they are very useful!
You're very welcome!
How to make select date & time & download button on dashboard? I want to download data in mysql, from node red dashboard.
The audio are ok something wrong are in your speakers.
Very good job 👌👍 well done ✅ keep the good job !!!
Ok, thank you
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? :)
ruclips.net/video/kIylVo8fxYY/видео.html
Great video . i need help please can you help me how to do data classification for diagnosis of patients using red nod ?
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?
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.
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.
Thank you so much!
No worries!
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.
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..
So easy bro 😊
how to ues php code in node red and fatch mysql database
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.
please help me , i need Dynamically add led_ui node in node red dashboard
@@groovheads give a javascript code please
previous video link ?
Here you go:
ruclips.net/video/cO8QpyUnEwg/видео.html
No sound :(
There is definitely sound - try refreshing the page or adjusting your audio settings. Thanks for watching!
@@Opto22 Yes indeed. Now I have sound. This is odd...
Phew! Glad to hear it. Thanks for watching!!
can you please give the link of the previous video. Couldn't find it
Here is the link to the Intro to the MySQL Node-RED Node video:
ruclips.net/video/kIylVo8fxYY/видео.html