sql error with foreign key

Question

The INSERT statement conflicted with the FOREIGN KEY constraint "FK_CHITIETDH__MaDH__4316F928". The conflict occurred in database [...]

But with the code here :

create database abc_1quanly111
use abc_1quanly111

create table abc_1nhacc
(
    MaNhaCC   varchar(10) primary key,
    TenNhaCC  varchar(50),
    DiaChiCC  varchar(50),
    Telephone varchar(50),
)

create table abc_1mamathang
(
    MaMH   varchar(10) primary key,
    TenMH  varchar(50) not null,
    DonGia  int check (DonGia>0),
    SoLuong int ,
    MaNhaCC varchar(10) foreign key references abc_1nhacc(MaNhaCC)
)
--Insert Nha CC --- Values -----
INSERT INTO abc_1nhacc VALUES('NC1','Phong Vu','123 NTMK ','0283232677')
INSERT INTO abc_1nhacc VALUES('NC2','Phong Hoang','123 NTD ','0290120217'),('NC3','THE GIOI DI DONG','12 LE VAN VIET ','028382901'),('NC4','NGUYEN KIM','23 LE DUAN ','01283232677'),('NC5','Phong KIM','13 LE LOI ','0288292677')
select * from abc_1nhacc
--Insert Mat Hang ---- Values ----
insert into abc_1mamathang values('M1','Laptop Sony',1000000,100,'NC1')
,
('M2','Laptop MSI GAMING',3200000,1,'NC2'),
('M3','Laptop ASUS',900000,10,'NC3'),
('M4','Laptop ACER',1340000,20,'NC4'),
('M5','Xperia A',10000,10,'NC5')
select * from abc_1nhacc
select * from abc_1mamathang

create table abc_1khachhang
(
    MaKhachHang      varchar(10) primary key,
    TenKhachHang     varchar(50),
    DiaChiKhachHang  varchar(50),
    PhoneKhachHang   varchar(10),
)
--Insert Khach Hang ---- Values ----
INSERT INTO abc_1khachhang values('KH1','Anh A','121 Le Duan Q1','09878721'),('KH2','Anh B','12 Quang Trung Q12','01878221'),('KH3','Anh C','331 Nguyen Thi Minh Khai','028787221'),('KH4','Anh D','23 Le Quang Dinh','09872321'),('KH5','Bac AD','','098787211')


create table abc_1dondathang
(
    MaSoDonDatHang varchar(10) primary key,
    NgayDatHang    DATE Default GetDate(),
    MaKhachHang varchar(10) foreign key references abc_1khachhang(MaKhachHang)
)
CREATE TABLE CHITIETDH
(
     MaDH varchar(10) foreign key references abc_1dondathang,
     MaMH varchar(10) foreign key references abc_1mamathang,
      Soluong int check (soluong>0)
      constraint pk_DHMH primary key(MaDH ,MaMH)
)

select * from abc_1dondathang
select * from abc_1mamathang
select * from CHITIETDH

insert into CHITIETDH values('DH1','MH1',12) // errors

select * from CHITIETDH

I don't know solution how to fix that, can anyone help me thanks.

Please don't include error messages as images. Other people might google the error and should find this question. — akraf, Jun 11 '18 at 15:13

score 0 · Answer 1 · answered Jun 11 '18 at 15:12

Your table CHITIETDH has a foreign key in table abc_1dondathang. You try to insert values to CHITIETDH while abc_1dondathang is empty. You must all the values under this column MaDH varchar(10) foreign key references abc_1dondathang will exist in abc_1dondathang before you insert something in CHITIETDH.

You can read here more.

sql error with foreign key

1 Answers1