表1 如下:
CREATE TABLE `test`.`test1` (
`test1_1` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
`test1_2` VARCHAR(45) NOT NULL,
`test1_3` VARCHAR(45) NOT NULL,
`test1_4` VARCHAR(45) NOT NULL,
`test1_5` VARCHAR(45) NOT NULL,
PRIMARY KEY(`test1_1`)
)
ENGINE = InnoDB;
表2如下:
CREATE TABLE `test`.`test2` (
`test2_1` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
`test2_2` VARCHAR(45) NOT NULL,
`test2_3` VARCHAR(45) NOT NULL,
`test1_1` INTEGER UNSIGNED NOT NULL,
`test1_2` VARCHAR(45) NOT NULL,
PRIMARY KEY(`test2_1`),
CONSTRAINT `test1_1` FOREIGN KEY `test1_1` (`test1_1`)
REFERENCES `test1` (`test1_1`)
ON DELETE RESTRICT
ON UPDATE RESTRICT,
CONSTRAINT `test1_2` FOREIGN KEY `test1_2` (`test1_1`)
REFERENCES `test1` (`test1_1`)
ON DELETE RESTRICT
ON UPDATE RESTRICT
)
ENGINE = InnoDB;
表3如下:
CREATE TABLE `test`.`test3` (
`test3_1` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
`test3_2` VARCHAR(45) NOT NULL,
`test3_3` VARCHAR(45) NOT NULL,
`test1_1` INTEGER UNSIGNED NOT NULL,
`test1_2` VARCHAR(45) NOT NULL,
`test1_3` VARCHAR(45) NOT NULL,
PRIMARY KEY(`test3_1`),
CONSTRAINT `test1_1` FOREIGN KEY `test1_1` (`test1_1`)
REFERENCES `test1` (`test1_1`)
ON DELETE RESTRICT
ON UPDATE RESTRICT,
CONSTRAINT `test1_2` FOREIGN KEY `test1_2` (`test1_1`)
REFERENCES `test1` (`test1_1`)
ON DELETE RESTRICT
ON UPDATE RESTRICT,
CONSTRAINT `test1_3` FOREIGN KEY `test1_3` (`test1_1`)
REFERENCES `test1` (`test1_1`)
ON DELETE RESTRICT
ON UPDATE RESTRICT
)
ENGINE = InnoDB;在这里创建表1(test1)没问题,创建第表2(test2)也没问题,创建表3(test3)的时候就是 ERROR 1005 (HY000): Can't create table 'test.test3' (errno: 121)这个错误。
然后把表2(test2)删掉然后创建表3(test3)可以创建,表3(test3)创建完了之后再创建表2的时候 还是这个错误。ERROR 1005 (HY000): Can't create table 'test.test2' (errno: 121)请高手指教。硬盘空间足够。
CREATE TABLE `test`.`test1` (
`test1_1` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
`test1_2` VARCHAR(45) NOT NULL,
`test1_3` VARCHAR(45) NOT NULL,
`test1_4` VARCHAR(45) NOT NULL,
`test1_5` VARCHAR(45) NOT NULL,
PRIMARY KEY(`test1_1`)
)
ENGINE = InnoDB;
表2如下:
CREATE TABLE `test`.`test2` (
`test2_1` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
`test2_2` VARCHAR(45) NOT NULL,
`test2_3` VARCHAR(45) NOT NULL,
`test1_1` INTEGER UNSIGNED NOT NULL,
`test1_2` VARCHAR(45) NOT NULL,
PRIMARY KEY(`test2_1`),
CONSTRAINT `test1_1` FOREIGN KEY `test1_1` (`test1_1`)
REFERENCES `test1` (`test1_1`)
ON DELETE RESTRICT
ON UPDATE RESTRICT,
CONSTRAINT `test1_2` FOREIGN KEY `test1_2` (`test1_1`)
REFERENCES `test1` (`test1_1`)
ON DELETE RESTRICT
ON UPDATE RESTRICT
)
ENGINE = InnoDB;
表3如下:
CREATE TABLE `test`.`test3` (
`test3_1` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
`test3_2` VARCHAR(45) NOT NULL,
`test3_3` VARCHAR(45) NOT NULL,
`test1_1` INTEGER UNSIGNED NOT NULL,
`test1_2` VARCHAR(45) NOT NULL,
`test1_3` VARCHAR(45) NOT NULL,
PRIMARY KEY(`test3_1`),
CONSTRAINT `test1_1` FOREIGN KEY `test1_1` (`test1_1`)
REFERENCES `test1` (`test1_1`)
ON DELETE RESTRICT
ON UPDATE RESTRICT,
CONSTRAINT `test1_2` FOREIGN KEY `test1_2` (`test1_1`)
REFERENCES `test1` (`test1_1`)
ON DELETE RESTRICT
ON UPDATE RESTRICT,
CONSTRAINT `test1_3` FOREIGN KEY `test1_3` (`test1_1`)
REFERENCES `test1` (`test1_1`)
ON DELETE RESTRICT
ON UPDATE RESTRICT
)
ENGINE = InnoDB;在这里创建表1(test1)没问题,创建第表2(test2)也没问题,创建表3(test3)的时候就是 ERROR 1005 (HY000): Can't create table 'test.test3' (errno: 121)这个错误。
然后把表2(test2)删掉然后创建表3(test3)可以创建,表3(test3)创建完了之后再创建表2的时候 还是这个错误。ERROR 1005 (HY000): Can't create table 'test.test2' (errno: 121)请高手指教。硬盘空间足够。
解决方案 »
- 求数据库原理教程课后答案
- 这些查询sql从那来的“SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM”
- 不知道大家有没有那种比较标准的配置文件~我这个db只作检索想提高检索的效率阿~
- postgresql 存储过程中遍历的一个小问题
- 求教mysq的l中文编码问题
- 请问那有WINDOWS和UNIX版的POSTGRESQL下载?
- 紧急求救:用mysql-front突然出现漏斗型的等待???(在线等,谢谢,以后补分)
- 在mysql中怎么去掉某个字段的unique属性啊?解决就给分
- 微信公众平台问题,求助
- mysql定时器,存储过程如何跨库全量,然后增量更新数据表
- mysql error no. 2003
- Mysql与Pgsql在PHP环境下能同时使用吗?
CREATE TABLE `test3` (
`test3_1` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
`test3_2` VARCHAR(45) NOT NULL,
`test3_3` VARCHAR(45) NOT NULL,
`test1_1` INTEGER UNSIGNED NOT NULL,
`test1_2` VARCHAR(45) NOT NULL,
`test1_3` VARCHAR(45) NOT NULL,
PRIMARY KEY(`test3_1`),
CONSTRAINT `test1_1` FOREIGN KEY `test1_1` (`test1_1`)
REFERENCES `test1` (`test1_1`)
ON DELETE RESTRICT
ON UPDATE RESTRICT,
CONSTRAINT `test1_2` FOREIGN KEY `test1_2` (`test1_1`)
REFERENCES `test1` (`test1_1`)
ON DELETE RESTRICT
ON UPDATE RESTRICT,
CONSTRAINT `test1_3` FOREIGN KEY `test1_3` (`test1_1`)
REFERENCES `test1` (`test1_1`)
ON DELETE RESTRICT
ON UPDATE RESTRICT
)
ENGINE = InnoDB;红色的名字与表2时的重复了。改一下。CREATE TABLE `test3` (
`test3_1` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
`test3_2` VARCHAR(45) NOT NULL,
`test3_3` VARCHAR(45) NOT NULL,
`test1_1` INTEGER UNSIGNED NOT NULL,
`test1_2` VARCHAR(45) NOT NULL,
`test1_3` VARCHAR(45) NOT NULL,
PRIMARY KEY(`test3_1`),
CONSTRAINT `test1_1_3` FOREIGN KEY `test1_1` (`test1_1`)
REFERENCES `test1` (`test1_1`)
ON DELETE RESTRICT
ON UPDATE RESTRICT,
CONSTRAINT `test1_2_3` FOREIGN KEY `test1_2` (`test1_1`)
REFERENCES `test1` (`test1_1`)
ON DELETE RESTRICT
ON UPDATE RESTRICT,
CONSTRAINT `test1_3_3` FOREIGN KEY `test1_3` (`test1_1`)
REFERENCES `test1` (`test1_1`)
ON DELETE RESTRICT
ON UPDATE RESTRICT
)
ENGINE = InnoDB;就可以了。
http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html
-> `test1_1` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
-> `test1_2` VARCHAR(45) NOT NULL,
-> `test1_3` VARCHAR(45) NOT NULL,
-> `test1_4` VARCHAR(45) NOT NULL,
-> `test1_5` VARCHAR(45) NOT NULL,
-> PRIMARY KEY(`test1_1`)
-> )
-> ENGINE = InnoDB;
Query OK, 0 rows affected (0.04 sec)mysql> CREATE TABLE `test`.`test2` (
-> `test2_1` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
-> `test2_2` VARCHAR(45) NOT NULL,
-> `test2_3` VARCHAR(45) NOT NULL,
-> `test1_1` INTEGER UNSIGNED NOT NULL,
-> `test1_2` VARCHAR(45) NOT NULL,
-> PRIMARY KEY(`test2_1`),
-> CONSTRAINT `test1_1` FOREIGN KEY `test1_1` (`test1_1`)
-> REFERENCES `test1` (`test1_1`)
-> ON DELETE RESTRICT
-> ON UPDATE RESTRICT,
-> CONSTRAINT `test1_2` FOREIGN KEY `test1_2` (`test1_1`)
-> REFERENCES `test1` (`test1_1`)
-> ON DELETE RESTRICT
-> ON UPDATE RESTRICT
-> )
-> ENGINE = InnoDB;
Query OK, 0 rows affected (0.04 sec)mysql> CREATE TABLE `test`.`test3` (
-> `test3_1` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
-> `test3_2` VARCHAR(45) NOT NULL,
-> `test3_3` VARCHAR(45) NOT NULL,
-> `test1_1` INTEGER UNSIGNED NOT NULL,
-> `test1_2` VARCHAR(45) NOT NULL,
-> `test1_3` VARCHAR(45) NOT NULL,
-> PRIMARY KEY(`test3_1`),
-> CONSTRAINT `test1_1_1` FOREIGN KEY `test1_1` (`test1_1`)
-> REFERENCES `test1` (`test1_1`)
-> ON DELETE RESTRICT
-> ON UPDATE RESTRICT,
-> CONSTRAINT `test1_2_1` FOREIGN KEY `test1_2` (`test1_1`)
-> REFERENCES `test1` (`test1_1`)
-> ON DELETE RESTRICT
-> ON UPDATE RESTRICT,
-> CONSTRAINT `test1_3_1` FOREIGN KEY `test1_3` (`test1_1`)
-> REFERENCES `test1` (`test1_1`)
-> ON DELETE RESTRICT
-> ON UPDATE RESTRICT
-> )
-> ENGINE = InnoDB;
Query OK, 0 rows affected (0.04 sec)mysql>