Up and Running with MySQL and NodeJS
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-mysq...
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/mys...
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
