React Node.js MySQL CRUD Tutorial for Beginners
Vložit
- čas přidán 25. 07. 2024
- MySQL CRUD Operations using Node.js and React. CRUD Real-world Project from scratch. Create, Read, Update and Delete data using a MySQL database.
If it is valuable to you, you can support Lama Dev.
Join: / @lamadev
Buy me a coffee: www.buymeacoffee.com/lamadev
Source Code: github.com/safak/youtube2022/...
Join Lama Dev groups
Facebook: / lamadev
Instagram: / lamawebdev
Discord: / discord
Twitter: / lamawebdev
00:00 Introduction
00:46 MySql Installation
02:20 MySql Basics
06:13 Node.js MySql Installation
11:04 Node.js MySql Fetch Data (Read)
13:07 Node.js MySql Create a New Data
18:34 Creating a React App
21:29 React How to Fetch Data From MySql
27:31 React Add New Data to MySql Database
32:21 React App Design
36:04 Node.js MySql Delete Operation
37:38 React MySql Delete Item From Database
39:10 React Node.js MySql How to Update Data
46:07 Outro - Věda a technologie
If you have problems, around minute 13:00, you can do what Lama said in the video,
*OR uninstall (npm un mysql) and install msql2 (npm in mysql2)* in vscode terminal.
Code change is: import mysql from 'mysql2'
thank you for information :)
Thank you so much, it worked, i almost went to google and chatgpt for help and they might have told me a process thats longer, Thank you so much @ThunderSlav
@@gcinumusaduma2112 {"code":"PROTOCOL_ENQUEUE_AFTER_FATAL_ERROR","fatal":false} getting this error can anyone help
Truly works! Thanks a lot👍
Thanks a lot man
Best mysql tutorial ever. I always wanted to make your social media app using a relational database. I hope it'll come true.
unlike the tutorials from other sources on the same topic, yours is the most informative and easiest to follow. Thanks a lot. I just subscribed!
This video is the best one compared with all others I watched, since you kept all the essence simple and clean, thank you a lot for making it!
This is has been the best 45 minutes my eyes have ever witnessed. You are such a magician.
Wow, finally you have done a video on how to integrate a relational database into a React and NodeJS application. I can't wait for the future video on the same technologies.
Yes, finaly using SQL.
It would be really nice a project with this stack:
1. Remix
2. Postregesql
3. Prisma
4. Tailwind
An app that includes:
1. CRUD operations.
2. Authentication/ Authorization.
3. Image Upload.
4. Maybe some kind of map display.
You are the best! I understood everything in the video so easily. You have a natural teaching skill, bro.
Hi Lama! You gained a new fan today. Aside from your soothing voice, the way you present information and explain it is wonderful! Thank you for this video, it was really easy to follow and learn from!
Your videos are so informative with concise tools and styling techniques, thank you!
I absolutely learned a lot, It is easy to follow and I understand every line of code I'm writing. What a great job you have done. It would be nice to see where and how to host this stack. Thank you
Thank you from the heart and appreciate your kindness. I believe that this is The video that I and many people have been waiting for.
The most well deserved subscribe I have ever given. Great tutorial. Thank you!
46mins of my time well spent!
Thanks for this tutorial, dude!
this might be the most straight forward tutorial i’ve ever seen
Это было круто! Перешёл на это видео с видео о создании блога. За эти 46 минут осознал работу mysql (в проекте заменил на mysql2), осознанно делал запросы в postman (а затем отловил ошибку 500 с его помощью и увидел ошибку в SQL запросе), подключал axios и использовал асинхронные запросы.
Lama Dev - спасибо, за объяснение и видео.
your tutorials have been blessing to me in person. i really want to appreciate you for been a role model, a blessing. furthermore, i plead with to do ecommerce tutorial with mysql. thank
AWESOME, thank you so much. Thanks for the MYSQL tutorial.
Lama sir, You are amazing. Thanks for helping novice like me to learn react.
Mega useful training for repeating the basics. Thank You :)
Thank you lama, was waiting for this.
Thanks for the great content, Lama dev. 💯❤️
This is exactly what i want, thank you for your video
Exactly what I needed, thank you!
Great tutorial I have ever seen on youtube😊. You are great teacher. Thank you sooooooooooo much
I love this guy called lamadev, taking it to the next level with MySQL
thanks Lama, you save my life, this is the best mysql tutorial ever.
wow been waiting for this tnks lot n God bless u now n always🤗
As usual one of the best. Many Thanks Safak
Thank you so much for your videos! And thanks for your time, effort and dedication to them!
Very good video. I have been looking for a tutorial like this for a while.
Each video is awesome in this channel, thanks
Amazing, helped me a lot, thanks for the class
Thanks for this type of tutorials sir your every video tutorials are life changing for me as a web dev.
fantastic tutorial, your simplicity is really admirable
Thank you for the tutorial. It's very clear. Thank you very much!!!
Thanks Lama, Learned basics of mysql.
thank you sir, straight to the point and also using a good English. Kudos
Hey Lama, thanks for great tutorial. I've jus finished my fullstack bootcamp and your projects help me to be in that learn/development process. Actually I'm making small app with backend & mysql db, and this helped me a lot. Can't wait to dig another projects!
Heh friend! Update is not working for me please help
@@iamjustastranger9473 me too,my add is also not working but everything else is okay
@@iamjustastranger9473 How did you fixed that?
@@leila_sinorew1160 How did you fixed that?
Want to tell thank you , you're a god , You helped me a LOT!
Best tutorial in CZcams.i was used to nosql db like firebase.so tutorials were hard.but your mysqli,workbench tutorial is good 😊
Thanks for the tutorial, I learned the sql part and how to marry it with react. I will let myself have my two cents thrown in about the front end part though. First - I don't think you need to store the input values in state and have them rerender the app with each change as we don't care here about the changes to these values, only for values in the moment of submitting, when you can simply read them directly from form data. Second - placeholders shouldn't be used as labels for readability and accessibility concerns. The more controls on a page the harder it gets to know what information goes where if you have them filled in and want to adjust one of them.
Thanks you so much brother lama. What we need is to learn building react projects with typescript and redux
thank you for this video, i am actually having fun! 🙂
Thank You lama for this awesome project
Was waiting for this
a lot of things to learn thanks alot lama dev
Thank you so much one more time LAMA.
For the fure I would like to see you creating a full stack app with react, nodejs, some database and a search engine framework like Elastic search for searching, auto-complete, etc.
AWESOME !!!! THIS IS ALL I NEED NOW !!!!
Great video!Thanks!
simple and clean MERN stack tutorial, thanks😀
thank you soo much. that video is best in youtube to understanding node crud
I did the same but using PostgreSQL as database. It worked. Thank you.
one of the best tutorials for beginners!!!
really great video,i was finding same video from last 15 days.expecting more content.
clear & concise thank you
Love this!
U r perfect and ur way of teaching awesome
Great!!! Hope you can make more react nodejs mysql videos. Have a nice day
Great tutorial from my mentor Lama
if you want to upload an image, you have to increase the the datatype in tables, from 45 to e.g. 255 or larger when uploading from external source like pexels, or unsplash
Thanks for everything, Lama dev is the best dev I have ever seen. I appreciate what you did for us! Thanks Lama
This helped me with my school project thanx boss
Thank you so much!
well done, it was a really good tutorial, but there were some improvements you can put into consideration, like instead of splitting the path name you could use useParams hook from react router dom it will return the parm directly without splitting, and for the image you could use multer for uploading files
i deleted all book items and when i added items through api call it adds the element id with (6) not 1 why ?
@@aditya1043you should TRUNCATE table to get ids back to 1
@@aditya1043 you need to reset it
Hey I got problem with images can you help me
Absolutely Great Sir 👍
Thank you Lama Dev ❤
It's great tutorial i've found. i've learned alot from your video. Really for beginner and it's easy to understand. Thanks Lama!! U helped me alot!!
Cool Lama 🎉
To be honest with you, I have learned a lot from you. I wish you get everything you need in this life
Ameen
Thank you a lot, this is helpful indeed
Thanks 4 this video, i learnt a lot
I decided to start learning MySQL this weekend, this video came just in time, thanks dude 👊. Make a unit test video too.
Thanks your Tutorials is amazing always i hope next project will be Pos or point of sale with Reactjs, nodejs and mysql
That's another one. Love u bro. Plz make a complete project like e-commerce with TypeScript, NextJS Redux, and MySQL.
Very clear and easy explanation 👌 🎉😊
You're a life saver!
Ty for saving my project ❤
Great and simple tutorial :))
Thanks for this great tutorial Lama, It gives fundamental knowledge of React, Node, and MySQL. It would be great if you can make a tutorial on point of sales(POS)
Yes exactly
What an explaination sir 🙌♥
Lama Thanks, You are the best teacher.. you just know whats right for me my brain lol
Really the best video👌. If possisble,website handling,not the React or other website,but HTML and CSS only
Great tutorial as always.. a School management base project in react that's design with MUI with firebase backend or MERN I think would make for a great video bro I've check and don't seem to find any such on CZcams think about it
hello viewers....
this video has great content for those who have minimum knowledge of the backend. today i learned how to connect and crud operation in both frontend and backend
before I don't know how to post or put frontend to backend he visualizes very clearly.
thank you Lama Dev... really i like this
and in a simple way all crud operations he teaches only based on one syntax without confusion..
Sir, I am extremely grateful for you and your channel.. I have learned a lot... Thank you sir
❤❤❤❤I is awsome..nomatter what...doing great thing like you gives peace of mind..mental satisfaction..you are realy my here..each peace of your content is at the target..easy and understandsble,and real life applications...to be honest i won't scroll another you tube video...Thank you so much❤❤❤
Yess more tutorials on MySQL
Awesome 👍
Thank you for share information
Perfect ♥️👽
Woah this tutorial was awesome!!! 🔥
👆Send a direct message for help 🆙 ⬆️
thank you man , very good performans
Hey, after installing react-router-dom, i'm getting this error -
^
SyntaxError: Unexpected token '
Mysql is very important, thanks, friend.
Thank you so much
Thank you!
Nice explaination ever seen and demonstration super😊😊😊
great...thankyou!!
A large e-learning platform using node js stream for video instead of url based video playing.. Great video btw
Great thanks bro...👍
Awesome tutorial lama, please can you do something on React-Native too