mysql5.5
CREATE TABLE IF NOT EXISTS testbool2(
id INT(5) KEY ZEROFILL AUTO_INCREMENT,
name VARCHAR(20) NOT NULL UNIQUE,
rmb FLOAT(5,2) NOT NULL );
結果
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ZEROFILL AUTO_INCREMENT,
name VARCHAR(20) NOT NULL UNIQUE,
rmb FLOAT(5,2) NOT NU' at line 2
我洗掉ZEROFILL就好了。。請問下這是什么原因？
uj5u.com熱心網友回復：
放錯位置了id INT(5) ZEROFILL KEY AUTO_INCREMENT
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/102444.html
標籤：MySQL