mysql - Vb.net MYSQL 外键约束

Question

我正在创建一个需要使用mysql的系统。我的表格已标准化为第三范式，但是当我执行代码时，它不会写入约会和纹身表，任何人都可以看到我做错了什么。这是我的sql语句:

    SQLstring = "database=Tattooing_By_name;server=localhost;user id=root;password="

    tables(0) = "CREATE TABLE Staff " & _
                 "(ID int NOT NULL AUTO_INCREMENT," & _
                 "staffname varchar(20)," & _
                 "StaffSurname varchar(20)," & _
                 "StaffcontactNO varchar(11)," & _
                 "StaffemailAdress varchar(40)," & _
                 "Staffpostcode varchar(8)," & _
                 "address varchar(40)," & _
                 "bio varchar(50)," & _
                 "username varchar(20)," & _
                 "Password varchar(20)," & _
                 "SecurityQ varchar(20)," & _
                 "SecAnswer varchar(20)," & _
                 "ResetCode varchar(15)," & _
                 "PRIMARY KEY (ID));"

    tables(1) = "CREATE TABLE Customers " & _
                 "(ID int NOT NULL AUTO_INCREMENT," & _
                 "Custname varchar(20)," & _
                 "Custsurname varchar(20)," & _
                 "CustcontactNO varchar(11)," & _
                 "CustemailAdress varchar(40)," & _
                 "Custpostcode varchar(8)," & _
                 "PRIMARY KEY (ID));"

    tables(2) = "CREATE TABLE Tattoo" & _
                 "(ID int NOT NULL AUTO_INCREMENT," & _
                 "StaffID int NOT NULL," & _
                 "CustomerID int NOT NULL," & _
                 "TattooDescription varchar(50)," & _
                 "PRIMARY KEY(ID)," & _
                 "FOREIGN KEY(StaffID) REFERENCES Staff(ID)," & _
                 "FOREIGN KEY(CustomerID) REFERENCES Customer(ID));"

    tables(3) = "CREATE TABLE Appointment" & _
                 "(ID int NOT NULL AUTO_INCREMENT," & _
                 "TattooID int," & _
                 "Deposit boolean," & _
                 "Cost int(10)," & _
                 "PRIMARY KEY (ID),FOREIGN KEY (TattooID) REFERENCES Tattoo(ID));"

Answer 1

当CREATE ... Tattoo时，您错过了Customers表名称中的s

"FOREIGN KEY(CustomerID) REFERENCES Customers(ID));"

或者您应该将 Customers 表重命名为 Customer :-)