React Node.js MySQL CRUD Tutorial for Beginners

If it is valuable to you, you can support Lama Dev.

Join Lama Dev groups

00:00 Introduction
00:46 MySql Installation
02:20 MySql Basics
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
37:38 React MySql Delete Item From Database
46:07 Outro

[ThunderSlav]

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'

[isaiuchiha]

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.

[coder]

Best mysql tutorial ever. I always wanted to make your social media app using a relational database. I hope it'll come true.

[gawadahmed]

This is has been the best 45 minutes my eyes have ever witnessed. You are such a magician.

[wisdomelue]

this might be the most straight forward tutorial i’ve ever seen

[codewithmorkeh]

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.

[ahmedmoussa]

To be honest with you, I have learned a lot from you. I wish you get everything you need in this life

[gilsoftcoder]

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!

[mingyangdiao]

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!

[slava_tfdf]

Это было круто! Перешёл на это видео с видео о создании блога. За эти 46 минут осознал работу mysql (в проекте заменил на mysql2), осознанно делал запросы в postman (а затем отловил ошибку 500 с его помощью и увидел ошибку в SQL запросе), подключал axios и использовал асинхронные запросы.

Lama Dev - спасибо, за объяснение и видео.

[betterbehappythannot]

You are the best! I understood everything in the video so easily. You have a natural teaching skill, bro.

[marcelloconcu]

Great tutorial! If you install and import mysql2 rather than mysql, you won't have authentication issues in the backend!

[rafaelfonseca]

46mins of my time well spent!
Thanks for this tutorial, dude!

[LightOSolid]

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!

[revansarbast]

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

[penniel.software]

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

[aviegrinberg]

Your videos are so informative with concise tools and styling techniques, thank you!

[sunerose]

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!

[puseefarpositputawan]

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.

[therealdevopsintern]

I love this guy called lamadev, taking it to the next level with MySQL