username VARCHAR(20) NOT NULL語法怎么錯了？
root@localhost t2>CREATE TABLE tb4(
??? -> id SMALLINT UNSIGNED PRIMARY KEY
??? -> username VARCHAR(20) NOT NULL
??? -> );
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'username VARCHAR(20) NOT NULL
)' at line 3
我用的MySQL 5.7.14版，什么原因出錯了？
2016-09-23
id 那一行最后加個，號
2016-09-23
id字段 PRIMARY KEY 后面少了一個逗號,
2016-09-23
第一個字段定義之后要加逗號