mysql - 错误代码:1826。重复的外键约束名称“menu_ibfk_1”
问题描述
我在 MySQL 上编写代码,它给了我错误。
这是我的代码,它给了我错误-“错误代码:1826。重复的外键约束名称'menu_ibfk_1'”
当我给出不同的约束名称时,它给了我错误-“错误代码:1822。无法添加外键约束。在引用的表'menu'中缺少约束'menu_ibfk_2'的索引”
create database WasteManagement;
CREATE TABLE WasteManagement.Faculty_login (
Faculty_ID int(9) NOT NULL ,
FName varchar(50) DEFAULT NULL,
Department varchar(20) DEFAULT NULL,
Password varchar(20) DEFAULT NULL,
PRIMARY KEY (Faculty_ID) );
CREATE TABLE WasteManagement.Student_login (
Enrollment_No int(11) NOT NULL ,
SName varchar(50) DEFAULT NULL,
Course varchar(20) DEFAULT NULL,
Password varchar(20) DEFAULT NULL,
PRIMARY KEY (Enrollment_No) );
CREATE TABLE WasteManagement.Staff_login (
Staff_ID int(9) NOT NULL ,
CName varchar(50) DEFAULT NULL,
Username varchar(20) DEFAULT NULL,
Password varchar(20) DEFAULT NULL,
PRIMARY KEY (Staff_ID) );
CREATE TABLE WasteManagement.Menu (
Staff_ID int(9) NOT NULL,
Datee date NOT NULL DEFAULT 0,
Timee varchar(10) NOT NULL,
Dish varchar(30) NOT NULL,
PRIMARY KEY (Datee, Timee, Dish)
#FOREIGN KEY (Staff_ID) References Menu(Staff_ID)
);
CREATE TABLE WasteManagement.Demand1 (
Datee date NOT NULL DEFAULT 0,
Timee varchar(10) NOT NULL,
Dish varchar(30) NOT NULL,
S_demand BOOLEAN DEFAULT FALSE,
PRIMARY KEY (Datee, Timee, Dish, S_demand),
KEY d1 (datee),
KEY t1 (Timee),
KEY dish1 (Dish),
#KEY `AuthorID` (`AuthorID`),
CONSTRAINT `menu_ibfk_1` FOREIGN KEY (Datee) References Menu(Datee),
CONSTRAINT `menu_ibfk_1` FOREIGN KEY (Timee) References Menu(Timee),
CONSTRAINT `menu_ibfk_1` FOREIGN KEY (Dish) References Menu(Dish));
CREATE TABLE WasteManagement.Demand2 (
Datee date NOT NULL DEFAULT 0,
Timee varchar(10) NOT NULL,
Dish varchar(30) NOT NULL,
F_demand BOOLEAN NOT NULL DEFAULT FALSE,
PRIMARY KEY (Datee, Timee, Dish, F_demand),
CONSTRAINT `menu_ibfk_1` FOREIGN KEY (Datee) References Menu(Datee),
CONSTRAINT `menu_ibfk_1` FOREIGN KEY (Timee) References Menu(Timee),
CONSTRAINT `menu_ibfk_1` FOREIGN KEY (Dish) References Menu(Dish));
CREATE TABLE WasteManagement.Feedback1 (
Datee date NOT NULL DEFAULT 0,
Timee varchar(10) NOT NULL,
Dish varchar(30) NOT NULL,
eaten_by1 int(7) NOT NULL,
s_rating int(1) NOT NULL,
PRIMARY KEY (Datee, Timee, Dish, eaten_by1, s_rating),
CONSTRAINT `menu_ibfk_1` FOREIGN KEY (Datee) References Menu(Datee),
CONSTRAINT `menu_ibfk_1` FOREIGN KEY (Timee) References Menu(Timee),
CONSTRAINT `menu_ibfk_1` FOREIGN KEY (Dish) References Menu(Dish));
CREATE TABLE WasteManagement.Feedback2 (
Datee date NOT NULL DEFAULT 0,
Timee varchar(10) NOT NULL,
Dish varchar(30) NOT NULL,
eaten_by2 int(7) NOT NULL,
f_rating int(1) NOT NULL,
PRIMARY KEY (Datee, Timee, Dish, eaten_by2, f_rating),
CONSTRAINT `menu_ibfk_1` FOREIGN KEY (Datee) References Menu(Datee),
CONSTRAINT `menu_ibfk_1` FOREIGN KEY (Timee) References Menu(Timee),
CONSTRAINT `menu_ibfk_1` FOREIGN KEY (Dish) References Menu (Dish));
CREATE TABLE WasteManagement.Wastage (
Datee date NOT NULL DEFAULT 0,
Timee varchar(10) NOT NULL,
Dish varchar(30) NOT NULL,
Produced_qty int(7) NOT NULL,
Wasted_qty int(7) NOT NULL,
PRIMARY KEY (Datee, Time, Dish, Produced_qty, Wasted_qty),
CONSTRAINT `menu_ibfk_1` FOREIGN KEY (Datee) References Menu(Datee),
CONSTRAINT `menu_ibfk_1` FOREIGN KEY (Timee) References Menu(Timee),
CONSTRAINT `menu_ibfk_1` FOREIGN KEY (Dish) References Menu(Dish));
这是 MySQL 输出的快照
我究竟做错了什么?
解决方案
外键必须引用完整的键:
FOREIGN KEY (Datee, Timee, Dish) References Menu(Datee, Timee, Dish)
每个约束都必须有自己的唯一名称。
推荐阅读
- mysql - 如何解决无法连接到任何指定的MySQL?
- android - 如何在 Agora 中像接听电话一样务实地视频呼叫另一个人,拒绝呼叫与 Android 中的 Whats 应用程序相同?
- javascript - 在浏览器窗口未聚焦时运行函数
- javascript - Fengyuanchen Datapicker - 箭头 prev/next
- python - 如何从文本文件中提取值?
- php - 已上传空文件
- kotlin - kotlin 语言翻译器中的“<”字符不起作用
- date - 累计应从不同开始日期的基值开始
- crc32 - 零长度检查的正确 CRC 值是多少?
- php - 未捕获的类型错误:$(...).combobox 不是函数