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

77 阅读 0 评论 51 点赞

我是靠谱客的博主犹豫宝马，最近开发中收集的这篇文章主要介绍mysql建外键时出现1064_我用mysql建表时出现了1064号错误，觉得挺不错的，现在分享给大家，希望可以做个参考。

概述

代码、错误提示如下：CREATETABLE`book`.`user`(`id`INTEGERUNSIGNEDNOTNULLAUTO_INCREMENT,`uid`VARCHAR(20)NOTNULL,`password`VARCHAR(30)NOTNULL,`realName`VARCHAR(20)NOTNULL,`g...

代码、错误提示如下：

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

展开