MySQL Notes

# Installation
sudo apt install mysql-server

# Start the server 
sudo mysql -u root -p

#show dbs
SHOW DATABASES;

# Create DB
CREATE DATABASE skillset;
CREATE DATABASE IF NOT EXISTS skillset;

# To Use the skillset
 USE skillset;
# To Show Tables 
 SHOW tables; 


#Drop DB
DROP DATABASE skillset;

# To Run sql file
source  table_create.sql