mysql ddl

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