SQL

mysql DDL

#建立一個名稱為t_test，字符集為utf8，儲存引擎為InnoDB，字元校驗集為utf8_general_ci的表：
mysql> CREATE TABLE t_test (
id INT NOT NULL AUTO_INCREMENT,
name VARCHAR(50),
PRIMARY KEY(id)
) ENGINE = InnoDB DEFAUL CHARSET = UTF8 COLLATE = utf8_general_ci;