Question

INSERT 语句与 COLUMN FOREIGN KEY 约束 'FK_MD' 冲突。怎么改？

create table
(
TypeCode varchar(10) primary key, --类别编码
TypeName varchar(20) --类别名称
)
insert into MedicineType values('MT001','')
insert into MedicineType values('MT002','')
insert into MedicineType values('MT003','')
insert into MedicineType values('MT004','')
insert into MedicineType values('MT005','')
go
--药品字典
create table MedicineDictionary
(
MDCode varchar(10) primary key, --药品编码
MDName varchar(60), --药品名称 一般20字左右
SpellCode varchar(10), --药品拼音码
TypeCode varchar(10) constraint FK_MD foreign key(TypeCode) references MedicineType(TypeCode) on update cascade, --药品类别编码
SpecContent varchar(6), --规格含量
MDUnit varchar(6), --药品单位
MDDose varchar(4), --药品剂型
Ingredient nvarchar(600), --药品成份
MDFunction nvarchar(600), --功能与主治
Usage nvarchar(400), --用法与用量
Memo nvarchar(400) --备注
)
insert MedicineDictionary
values('001','克里克','klk','M001','5克','克','胶囊','乙酸胺','止痛','口服','')
insert MedicineDictionary
values('002','枇杷糖浆','patj','M002','50ml','ml','液体','甲苯','止咳','口服','')
insert MedicineDictionary
values('003','阿莫西林','xl','M003','3克','克','胶囊','青霉素','消炎','口服','')
insert MedicineDictionary
values('004','止痛片','zt','M004','2克','克','片状','抗生素','止痛','口服','')
insert MedicineDictionary
values('005','罗红霉素','lhms','M005','4克','克','颗粒','抗生素','消炎','口服','')

Answer 1

1、insert into MedicineType values('MT001','')
2、insert MedicineDictionary values('001','克里克','klk','M001','5克','克','胶囊','乙酸胺','止痛','口服','')
两个语句中，一个是MT001，一个是M001。M001要改成MT001