我用mysql建表时出现了1064号错误

代码、错误提示如下:
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

第1个回答  2009-09-28
`gender` TINYINT(1)) UNSIGNED NOT NULL DEFAULT 0,
这句啥意思。。。本回答被提问者采纳
相似回答