https://dbdocs.io/mentorx.india/ecommerce_v1

Mysql Installation

Linux

Windows

Installation

Installation

# Download
sudo apt install mysql-server

# Setup password
sudo mysql_secure_installation

# Start Mysql
sudo systemctl start mysql

Download xampp https://www.apachefriends.org/download.html

# Open xampp, start mysql > shell

# Setup password
mysqladmin -u root password123

• Connect to Mysql

sudo mysql -u root -p

mysql -u root -p

SQL (Structured Query Language) Basics

-- show all databases
show databases;

-- create database
create database shilpa_ecommerce_db;

-- use or open database
use shilpa_ecommerce_db;

-- show all tables in database
show tables;

SQL CRUD (Create or Insert, Read or Select, Update, Delete)

Create Table users

CREATE TABLE users (
		id int NOT NULL PRIMARY KEY AUTO_INCREMENT,
		name varchar(127) NOT NULL,
		gender enum('MALE', 'FEMALE', 'OTHER') NOT NULL,
		email varchar(127) UNIQUE NOT NULL,
		mobile varchar(15) UNIQUE NOT NULL,
		password varchar(255) NOT NULL,
		otp varchar(7),
		created_at timestamp DEFAULT (CURRENT_TIMESTAMP),
		updated_at timestamp DEFAULT (CURRENT_TIMESTAMP),
		INDEX email_idx (email),
		INDEX mobile_idx (mobile)
);

Single Row Insert