dqtl46964 2015-08-11 12:55
浏览 67
已采纳

单个主键的2个外键引用

I have 3 tables: agreement, user, emails as follows and the id in user table is acting as a foreign key in email table(id(FK)) as well as agreement table id_two(FK).

enter image description here

I have referenced id(Foriegn Key) in emails table to id(Primary key) in user table using the below code successfully:

ALTER TABLE emails MODIFY COLUMN id INT NOT NULL,
 ADD CONSTRAINT id
 FOREIGN KEY(id)
 REFERENCES user(id);

But i am getting an error #1022 - Can't write; duplicate key in table '#sql-13f0_30e'

when i execute the below query to refer id_two of agreement table to id(PK) of user table.

ALTER TABLE agreement MODIFY COLUMN id_two INT NOT NULL,
 ADD CONSTRAINT id_two
 FOREIGN KEY(id_two)
 REFERENCES user(id);

</div>
  • 写回答

3条回答 默认 最新

  • doudui1850 2015-08-11 13:01
    关注

    That's most probably because you already have a constraint defined in agreement table named id_two. Change the name of the constraint and see

    ALTER TABLE agreement MODIFY COLUMN id_two INT NOT NULL,
     ADD CONSTRAINT id_FK2
     FOREIGN KEY(id_two)
     REFERENCES user(id); 
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(2条)

报告相同问题?

悬赏问题

  • ¥15 为啥快手广告联盟的广告这么难出来
  • ¥15 k8s集群重启后,kubelet一直报systemctl restart kubelet.service "Failed to delete cgroup paths"
  • ¥15 微信小程序构建工具类发布到npm,install后报错
  • ¥15 amesim液压仿真问题
  • ¥15 MATLAB优化设计
  • ¥15 ANN预测模型 200大米
  • ¥20 优秀学生的问题 oj java
  • ¥15 scratch-gui 如何集成进 react native
  • ¥15 把全局悬浮窗改为局内悬浮窗
  • ¥15 Excel vba编程调用word如何读取换行符