create table user(uid int);
create table secuser(id int,sid int);
alter table secuser add constraint fk_sid foreign key (sid) references user(uid);
这样设置外键怎么老是报ERROR 1005 (HY000): Can't create table '.\ptest\#sql-6cc_4.frm' (errno: 150)错误呢
create table secuser(id int,sid int);
alter table secuser add constraint fk_sid foreign key (sid) references user(uid);
这样设置外键怎么老是报ERROR 1005 (HY000): Can't create table '.\ptest\#sql-6cc_4.frm' (errno: 150)错误呢
Query OK, 0 rows affected (0.06 sec)
Records: 0 Duplicates: 0 Warnings: 0mysql> alter table secuser add constraint fk_sid foreign key (sid) references user(uid);
Query OK, 0 rows affected (0.05 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> create table user(uid int primary key);
Query OK, 0 rows affected (0.02 sec)mysql> create table secuser(id int,sid int);
Query OK, 0 rows affected (0.03 sec)mysql> alter table secuser add constraint fk_sid foreign key (sid) references user(uid);
Query OK, 0 rows affected (0.04 sec)
Records: 0 Duplicates: 0 Warnings: 0
2) user表的存储引擎必须是innodb