我这个创建表的语句请求老师傅看看,错在什么地方
小小nb 2017-12-13 11:26:24 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就好了。。请问下这是什么原因?