تقييمات الطلاب
( 5 من 5 )
١ تقييمات
فيديو شرح Up and Running with MySQL and NodeJS ضمن كورس MySQL SQL شرح قناة Steve Griffith - Prof3ssorSt3v3، الفديو رقم 40 مجانى معتمد اونلاين
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