试图在phpmyadmin中设置外键

2 回答

• 0

  确保两种列类型相同 . 没有它，它将不会显示在您的下拉列表中/无法保存

  回复于 2024-05-06T01:58:32+08:00
• 0

  只需转到sql并使用以下查询

  ALTER TABLE `table_name_with_foreignKey`
    ADD CONSTRAINT `foreignKey_constraint_name` 
    FOREIGN KEY (`Column_name_of_foreignkey`) 
    REFERENCES `table_having_referenceTokey`(`column_name_of_primaryKey`) 
    ON DELETE CASCADE 
    ON UPDATE CASCADE;
  

  回复于 2024-05-06T01:58:32+08:00