MySQL CLI Most Used

Database

Create Database

CREATE Database_Name

Show Databases

SHOW DATABASES;

Delete Database

DROP DATABASE Database_Name;

Tables

Create Table

CREATE TABLE Database_Name.Table_Name (Field_1 INT [PRIMARY KEY], Field_2 VARCHAR(20));

Show Tables

SHOW [FULL] TABLES [FROM Database_Name] [LIKE 'pattern'];

Delete Table

DROP TABLE Database_Name.Table_Name;

Table Data Manipulation

Select data from a Table

SELECT * FROM Database_Name.Table_Name;

Insert data into a Table

INSERT INTO Database_Name (Field_Name_1, Field_Name_2) VALUES (["]Data_01["], ["]Data_02["]);

Table Data Manipulation Properties

Describe Field Formats for a Table

DESCRIBE Database_Name.Table_Name];