代码、错误提示如下:
CREATE TABLE `book`.`user` (
`id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
`uid` VARCHAR(20) NOT NULL,
`password` VARCHAR(30) NOT NULL,
`realName` VARCHAR(20) NOT NULL,
`gender` TINYINT(1)) UNSIGNED NOT NULL DEFAULT 0,
`email` VARCHAR(50) NOT NULL,
`tel` VARCHAR(15) DEFAULT NULL,
`question` VARCHAR(50) DEFAULT NULL,
`validateCode` VARCHAR(20) NOT NULL,
`answer` VARCHAR(50) NOT NULL,
`loginNum` INTEGER UNSIGNED NOT NULL DEFAULT 0,
PRIMARY KEY (`id`)
)
ENGINE = InnoDB
CHARACTER SET utf8 COLLATE utf8_general_ci
COMMENT = 'InnoDB free:11264 kB';
Error: 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 ‘UNSIGNED NOT NULL DEFAULT 0,
email VARCHAR(50) NOT NULL
tel VARCHAR(15)' at line 6