我正在处理一个带有外键的表,它就在这里。create table PM_Team_Members
(
PM_Team_Members_ID int NOT NULL auto_increment PRIMARY KEY,
PM_Team_Members_firstName varchar(50) not null,
PM_Team_Members_middleName varchar(50) not null,
PM_Team_Members_lastName varchar(50) not null,
PM_Team_Members_address varchar(255) not null,
PM_Team_Members_contact numeric not null,
PM_Spec_id int,
constraint fk_PM_id foreign key (PM_Spec_id) references PM_Specialization(PM_Spec_id)
)
这是参考表create table PM_Specialization
(
PM_Spec_ID int auto_increment PRIMARY KEY,
PM_Spec_Specialization varchar(50) not null,
PM_Spec_Description varchar(255) not null
)
当我点击GO进行查询时。它说MySQL returned an empty result set (i.e. zero rows). (Query took 0.2162 sec)
,我认为它是正确的。但随后弹出显示错误:令牌不匹配
怎么了?是我做错了什么,还是某种错误?
此部件references PM_Specialization(PM_Spec_id) )
您的PM_Specialization表中有PM_Spec_ID而不是PM_Spec_ID。