mysql创建外键失败_mysql创建外键错误

三张表，tb_goods，tb_sort，userforme，给给tb_goods表的sort_id列创建外键，关联tb_sort的id，出错。mysql>desctb_goods;+-----------+--------------+------+-----+---------+----...

三张表， tb_goods， tb_sort， userforme ，给给tb_goods表的sort_id列创建外键，关联tb_sort的id，出错。

mysql> desc tb_goods;

+-----------+--------------+------+-----+---------+----------------+

| Field | Type | Null | Key | Default | Extra |

+-----------+--------------+------+-----+---------+----------------+

| id | int(6) | NO | PRI | NULL | auto_increment |

| name | varchar(20) | NO | | NULL | |

| sort_id | int(6) | NO | | NULL | |

| type | char(1) | NO | | NULL | |

| price | double(6,2) | NO | | NULL | |

| introduce | varchar(200) | NO | | NULL | |

+-----------+--------------+------+-----+---------+----------------+

mysql> desc tb_sort;

+-------+-------------+------+-----+---------+----------------+

| Field | Type | Null | Key | Default | Extra |

+-------+-------------+------+-----+---------+----------------+

| id | int(6) | NO | PRI | NULL | auto_increment |

| name | varchar(20) | NO | | NULL | |

+-------+-------------+------+-----+---------+----------------+

mysql> alter table tb_sort add constraint FK_sort_goods foreign key(id) references tb_goods(sort_id);

ERROR 1005 (HY000): Can't create table 'mysqldb.#sql-c54_1' (errno: 150)

看过一些资料，还是没看出来，请大家帮看看~

http://hi.baidu.com/itsuperman_/item/ecc4a478b6315e025d178930

展开