Student Reviews
( 5 Of 5 )
1 review
Video of Up and Running with MySQL and NodeJS in MySQL SQL course by Steve Griffith - Prof3ssorSt3v3 channel, video No. 40 free certified online
This tutorial covers how to install MySQL on your computer and then how to integrate the mysql2 npm package with an Express application to create an API that uses MySQL as the backend.
Websites referenced in the video:
https://sidorares.github.io/node-mysql2/docs
https://dev.mysql.com/doc/refman/8.4/en/
https://http.cat/
https://www.mamp.info/en/downloads/
https://ampps.com/wamp/
https://www.apachefriends.org/
Code from tutorial:
https://github.com/prof3ssorSt3v3/mysql-node
0:00 Overview
1:40 MAMP setup
3:50 MySQL from Terminal
8:21 Creating Users and Database
14:22 Project config
19:05 Connecting to MySQL
22:55 Managing DB from Node
31:10 API endpoints
36:08 SELECT with query method
41:16 Errors and HTTP status codes
46:00 INSERT with execute method
53:09 UPDATE with execute
58:04 Testing in browser & postman