為什么帶主鍵約束的數據表創建不了???
mysql> CREATE TABLE tb3(
? ? -> id SMALLINT UNSIGNED AUTO_INCREMENT PRIMAYR 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 'PRIMAYR KEY,
username VARCHAR(20) NOT NULL
)' at line 2
mysql>
2016-11-16
PRIMAYR KEY ? 寫錯啦 ? 是PRIMARY KEY