An overview of all statements in mysql

Reference subject: http://c.biancheng.net/view/2600.html1.CREATE main clause

CREATE DATABASE IF NOT EXISTS DEFAULT CHARACTER SET DEFAULT COLLATE

CREATE TABLE IF NOT EXISTS ([] [, []])

Integer type: TINYINT, SMALLINT, MEDIUMINT, INT, BIGINT floating point number type: FLOAT, DOUBLE fixed point number type: DECIMAL date / time type: YEAR, TIME, DATE, DATETIME, TIMESTAMP string type: CHAR, VARCHAR, TINYTEXT, TEXT, MEDIUMTEXT, LONGTEXT, ENUM, SET binary type: BIT, BINARY, VARBINARY, TINYBLOB, BLOB, MEDIUMBLOB, LONGBLOB primary key constraint: PRIMARY KEY, PRIMARY KEY (primary key column 1, primary key column 2, … , primary key column n) foreign key constraint: [CONSTRAINT] FOREIGN KEY (foreign key column 1, foreign key column 2, … Foreign key column n) REFERENCES (primary key column 1, primary key column 2, … , primary key column n) unique constraint: UNIQUE, CONSTRAINT UNIQUE () check constraint: CHECK (), CONSTRAINT CHECK () non-empty constraint: NOT NULL default value constraint: DEFAULT

CREATE VIEW [(column 1, column 2, … , column name n)] AS

CREATE FUNCTION ([[,] *]) RETURNS

CREATE PROCEDURE [.] ([[IN | OUT | INOUT] [, [IN | OUT | INOUT]] *])

Custom closing symbol: DELIMITER

CREATE TRIGGER [.]

ON FOR EACH ROW

CREATE [UNIQUE] INDEX ON ([] [ASC | DESC] [, [] [ASC | DESC]] *)

CREATE USER IDENTIFIED BY [PASSWORD]