$ git clone https://github.com/shubhamns/node-express-mysql-crud-app.git
$ cd PROJECT_TITLE
$ npm install
1. install mysql
2. you can also download mysql GUI `mysql workbench`.
3. paste host, user, password, database to `database/mysqlDB.js`
4. CREATE DATABASE crud;
5. CREATE TABLE users(
_id INT NOT NULL AUTO_INCREMENT,
firstName VARCHAR(45) NOT NULL,
lastName VARCHAR(45) NOT NULL,
email VARCHAR(45) NOT NULL,
createdAt DATETIME NULL,
updatedAt DATETIME NULL,
PRIMARY KEY (_id),
UNIQUE INDEX _id_UNIQUE (_id ASC),
UNIQUE INDEX email_UNIQUE (email ASC));
create table blogs(
id bigint unsigned AUTO_INCREMENT primary key,
title varchar(255),
content TEXT,
created_at timestamp default now(),
updated_at timestamp default now()
);