56,679
社区成员
发帖
与我相关
我的任务
分享
第一次执行:
alter table t_user add constraint u_order_id2o_id
foreign key t_user(u_order_id)
references t_order (o_id)
on delete cascade on update cascade;
成功
第二次执行
alter table t_user add constraint u_paid_id2p_id
foreign key t_user(u_paid_id)
references t_paid (p_id)
on delete cascade on update cascade;
报错:ERROR 1061 (42000): Duplicate key name 't_user'
求大神
alter table t_user add constraint u_paid_id2p_id
foreign key (u_paid_id)
references t_paid (p_id)
on delete cascade on update cascade;