- 论坛徽章:
- 13
|
本帖最后由 hmchzb19 于 2016-05-24 14:08 编辑
1. 我先是建了两个表。- CREATE TABLE employee(
- employee_id int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- last_name VARCHAR(30) NOT NULL,
- first_name VARCHAR(30) NOT NULL,
- email VARCHAR(100) NOT NULL,
- hire_date DATE NOT NULL,
- notes MEDIUMTEXT,
- PRIMARY KEY(employee_id),
- INDEX(last_name),
- UNIQUE(email)
- )ENGINE=InnoDB;
- CREATE TABLE address(
- employee_id int(10) UNSIGNED NOT NULL,
- address VARCHAR(50) NOT NULL,
- city VARCHAR(30) NOT NULL,
- state CHAR(2) NOT NULL,
- postcode CHAR(5) NOT NULL,
- FOREIGN KEY(employee_id)
- REFERENCES employee(employee_id) )
- ENGINE=InnoDB;
复制代码 然后我drop 了表address, 打算重建这个表。- SET FOREIGN_KEY_CHECKS = 0;
- drop table address;
复制代码 重建表就一直报错。- mysql> CREATE TABLE address(
- -> employee_id int(10) UNSIGNED NOT NULL,
- -> address VARCHAR(50) NOT NULL,
- -> city VARCHAR(30) NOT NULL,
- -> state CHAR(2) NOT NULL,
- -> postcode CHAR(5) NOT NULL,
- -> FOREIGN KEY(employee_id)
- -> REFERENCES employee(employee_id) on update cascade ON DELETE CASCADE)
- -> ENGINE=InnoDB;
- ERROR 1005 (HY000): Can't create table 'sakila.address' (errno: 150)
复制代码 为什么?
因为我没有删除干净什么东西吗?
|
|