MySQL Node.js Express

I'll show you how to connect your node application to a MySQL database to query and insert data. I will also show you how to integrate this into an express server to show what a complete backend might look like.

Chapters:
0:00​ Intro
0:32 Setup MySQL
1:50 Setup Node App
2:46 Connect to MySQL from Node
4:40 Basic Queries
7:24 Environment Variables
10:22 Prepared Statements
13:42 Insert Statement
17:58 Express
26:00 Error Handling
27:28 Summary

🔗Code & Resources:

🔗Express JS Crash Course

🔗Moar Links

[tye-gehring]

I've watched tons of different coding tutorials, this was by far one of my favorites. You do an amazing job and I hate to see that you haven't added anything in the last few months. Please keep it up, you are very good at explaining things.

[fluffybubble]

This is one of the best tutorials about using MySQL with Node in youtube. I really enjoyed watching your tutorial and gained a lot of usefull knowledge about topic. You really did a great job !

[danielmadison]

What is clean code? Hard to define, but you know it when you see it. THIS is CLEAN CODE. Thanks for showing all of us how it's done.

[ToddSotheren-ub]

Thank god someone can actually explain this clearly, comprehensively and concisely - everything I needed to know and nothing I didn't - much appreciated mate 👍

[marcelmeyer]

I'm a complete newbie to development and JS. Only been sincerely interested in the topic of software development for a few months now.

First watched this Video a few weeks ago and didn't understand a lot of it, let alone all. I guess I just wasn't ready for it.

Watched it again now, after a lot of reading and watching other videos which were all more or less helpful.

And I must say:
At this point, all makes perfect sense to me and I am positively amazed as to how much knowledge and practical advice you can put into less then 30 min. of video.

Respect for all your skills and thanks for sharing it!

[huyhoangngo]

I've been watching a lot of tutorials on connecting MySQL to VSCode and using ExpressJS to implement it. None of the videos gave me a clear idea of what to do. But when I watched your video, you basically made everything clear to me. Just wanted to say thanks for the instructions and keep up the good work.

[phantom]

I can't even wrap my head around on how you packed this much of AMAZING content in such a small video. Hats off to you.

[koopa]

Thanks so much! I LOVE LOVE LOVE how you explain the context of why we write the code a certain way. Helps me out so much knowing background info and prevents me from just following along too blindly!

[Fran-mqmu]

Man, you don't even know how this video helped me, thank you so much for the didactics and for keeping the language simple for those who aren't natives!

[davidmd]

All your tutorials are great to follow on practice without missing attribute you have got!!

[TheChad]

This tutorial is amazing! Very straightforward

[matthewdavidson]

Absolutely amazing! So much knowledge passed through in less than 30 mins. Please keep building and keep making vids

[davidbarker]

This is a really good guide to using MySQL with express. I first completed the prior tutorial, the Express JS Crash Course. I extended the work I did there during this MySQL tutorial with only a few minor tweaks - uninstalled express 4, installed express 5 beta. Used server.js instead of app.js. Had to change to use ES modules instead of commonjs, so I had to remove 'require' and use imports. Then the rest of the changes were just in database.js (in the first tutorial, it's just a hard-coded in-memory object). It works great! Thanks!

[mashablair]

I love this!! especially the voice of the instructor -- I can listen to it all day! 😀
i was afraid of mysql (connecting it to some front-end code) for a long time and this is super helpful. thank you.

[lovelyalicekim]

I really love your tutorial which is straightforward and clear. Especially mentioning like why it is the better way to write code. Super helpful!!

[Antel_]

watching this pretty late but I enjoyed every bit of it. I really love how you made the everything connect and how information can be accessed and modified through different channels. great work. Thanks for this.

[sgm]

Great video. Love how you should your errors, the error message, and how to fix them. Very refreshing.

[chriskiesel]

Fantastic! I really enjoyed this honestly, I kept pausing and rewinding the clip over and over and not because it was hard to grasp rather was your delivery, absolute fire . I am so happy for accidentally coming across your channel you're a real one Sam, Cheers.

[Alex-wgbi]

Great video! As a computer science student who has studied these concepts/frameworks in class, this was a fantastic streamlined refresher!

[Hemantraghav-vpff]

It is very helpful video for those looking for 'how to connect node.js app to Mysql ". To-the-point tutorial.