Mysql5.5


The CREATE TABLE IF NOT EXISTS testbool2 (
Id INT (5) KEY ZEROFILL AUTO_INCREMENT,
NOT NULL UNIQUE name VARCHAR (20),
RMB FLOAT (5, 2) NOT NULL);

The results
ERROR 1064 (42000) : You have an ERROR in your SQL syntax; Check the manual that corresponds to MariaDB server version for the right syntax to use near 'ZEROFILL AUTO_INCREMENT,
NOT NULL UNIQUE name VARCHAR (20),
RMB FLOAT (5, 2) NOT NU 'at line 2

I am ok, delete ZEROFILL, excuse me what reason is this?

CodePudding user response:

Put the wrong position
Id INT (5) ZEROFILL KEY AUTO_INCREMENT