mysql - 我的 SQL 代码不断出现此错误

Question

错误说:

#1064 - 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 '' at line 9

我的查询:

CREATE TABLE `login`.`login`(
`id` SERIAL NOT NULL,
`user` VARCHAR(20)NOT NULL,
`pass` VARCHAR(30) NOT NULL,
PRIMARY KEY(`id`),
UNIQUE(
`user`,
`pass`
)

Answer 1

试试这个

CREATE TABLE `login`(
`id` INT( 11 ) AUTO_INCREMENT NOT NULL,
`user` VARCHAR(20)NOT NULL,
`pass` VARCHAR(30) NOT NULL,
PRIMARY KEY(`id`),
UNIQUE(`user`,`pass`)
)