Connect to the database mysql -uroot -p -P3306
List databases SHOW DATABASES;
Create a database CREATE DATABASE DBname;
Select a database USE DBname;
List tables SHOW TABLES;
Create a table CREATE TABLE TBname(name VARCHAR(20),age TINYINT);
Insert a record INSERT INTO TBname VALUES(‘Lee’,20);
View table structure DESCRIBE TBname;SHOW COLUMNS FROM TBname;
View table contents SELECT * FROM TBname;
Drop a table DROP TBname;
Unsigned UNSIGNED
Auto-increment AUTO_INCREMENT
Disallow NULL NOT NULL
Set primary key PRIMARY KEY
Unique constraint UNIQUE KEY
Default constraint ENUM(‘1′,’2′,’3’) DEFAULT ‘3’