我的sql语句
:alter table personstory add constraint FK_Reference_user_personstory foreign key (userID)
references user(userID) on delete restrict on update restrict;
错误提示:
Error Code : 1005
Can't create table '.\dep\#sql-3b8_1.frm' (errno: 121)Execution Time : 00:00:00:000
Transfer Time : 00:00:00:000
Total Time : 00:00:00:000
:alter table personstory add constraint FK_Reference_user_personstory foreign key (userID)
references user(userID) on delete restrict on update restrict;
错误提示:
Error Code : 1005
Can't create table '.\dep\#sql-3b8_1.frm' (errno: 121)Execution Time : 00:00:00:000
Transfer Time : 00:00:00:000
Total Time : 00:00:00:000
Query OK, 0 rows affected (0.01 sec)mysql> create table b (a int ,userid int);
Query OK, 0 rows affected (0.00 sec)mysql> alter table b add constraint FK_Reference_user_personstory foreign key (userID)
-> references a(userID) on delete restrict on update restrict;
Query OK, 0 rows affected (0.04 sec)
Records: 0 Duplicates: 0 Warnings: 0