Express_MySql_Activity

Practicing connecting Node.js to MySql

Tech Stack

• Express
• MySql

Optional

• Postman
• nodemon npm install nodemon

Setup

Create a database with a table, columns, and records.

CREATE DATABASE databasename;
USE databasename;
CREATE TABLE table_name (
    column1 datatype,
    column2 datatype,
    column3 datatype,
);
INSERT INTO table_name
VALUES (value1, value2, value3, ...);

Install Express: npm install express

Install all dependencies: npm install

Install Mysql: npm install mysql