Untitled

mail@pastecode.io avatar
unknown
plain_text
2 years ago
4.6 kB
6
Indexable
Never
INSERT INTO KHACHHANG
    (MaKH , HoTen , DiaChi, SDT , NgSinh , DoanhSo , NdDK)
VALUES
    ('KH01','Nguyen Van A','731 Tran Hung Dao , Q5 ,TPHCM','08823451','1967-10-22','13060000','2006-07-22')
INSERT INTO KHACHHANG
    (MaKH , HoTen , DiaChi, SDT , NgSinh , DoanhSo , NdDK)
VALUES
    ('KH02','Tran Ngoc Han','23/5 Nguyen Trai , Q5 TPHCM','090815664','1974-4-3','280000','2006-07-30')
INSERT INTO KHACHHANG
    (MaKH , HoTen , DiaChi, SDT , NgSinh , DoanhSo , NdDK)
VALUES
    ('KH03','Tran Ngoc Linh','45 Nguyen Canh Chan ,Q1 TPHCM','095165431','1974-6-12','3860000','2006-08-5')
INSERT INTO KHACHHANG
    (MaKH , HoTen , DiaChi, SDT , NgSinh , DoanhSo , NdDK)
VALUES
    ('KH04','Tran Minh Long','50/34 Le Dai Hanh . Q10 TPHCM','0956816548','1974-3-9','250000','2006-10-2')
INSERT INTO KHACHHANG
    (MaKH , HoTen , DiaChi, SDT , NgSinh , DoanhSo , NdDK)
VALUES
    ('KH05','Le Nhat Minh','34 Truong Dinh , Q3 TPHCM','090456484','1974-3-10','21000','2006-10-28')
INSERT INTO KHACHHANG
    (MaKH , HoTen , DiaChi, SDT , NgSinh , DoanhSo , NdDK)
VALUES
    ('KH06','Le Hoai Thuong','227 Nguyen Van Cu','06543145','1974-12-31','915000','2006-11-24')
INSERT INTO KHACHHANG
    (MaKH , HoTen , DiaChi, SDT , NgSinh , DoanhSo , NdDK)
VALUES
    ('KH07','Nguyen Van Tam','32/3 Tran Binh Trong ','090854984','1974-4-6','12500','2006-12-1')
INSERT INTO KHACHHANG
    (MaKH , HoTen , DiaChi, SDT , NgSinh , DoanhSo , NdDK)
VALUES
    ('KH08','Phan Thi Thanh','45/2 An Duong Vuong ','054875664','1974-1-10','365000','2006-12-13')

--nhap cthd
INSERT INTO CTHD
	(SoHD , MaSP , SoLuong)
VALUES
	('1001','TV02','10')
INSERT INTO CTHD
	(SoHD , MaSP , SoLuong)
VALUES
	('1001','ST01','5')
INSERT INTO CTHD
	(SoHD , MaSP , SoLuong)
VALUES
	('1001','BC01','5')
INSERT INTO CTHD
	(SoHD , MaSP , SoLuong)
VALUES
	('1001','BC02','10')
INSERT INTO CTHD
	(SoHD , MaSP , SoLuong)
VALUES
	('1001','ST08','10')
INSERT INTO CTHD
	(SoHD , MaSP , SoLuong)
VALUES
	('1002','BC04','20')
INSERT INTO CTHD
	(SoHD , MaSP , SoLuong)
VALUES
	('1002','BB01','20')
INSERT INTO CTHD
	(SoHD , MaSP , SoLuong)
VALUES
	('1002','BB02','20')
INSERT INTO CTHD
	(SoHD , MaSP , SoLuong)
VALUES
	('1003','BB03','10')
INSERT INTO CTHD
	(SoHD , MaSP , SoLuong)
VALUES
	('1004','TV01','20')
INSERT INTO CTHD
	(SoHD , MaSP , SoLuong)
VALUES
	('1004','TV02','10')
INSERT INTO CTHD
	(SoHD , MaSP , SoLuong)
VALUES
	('1004','TV03','10')
INSERT INTO CTHD
	(SoHD , MaSP , SoLuong)
VALUES
	('1004','TV04','10')
INSERT INTO CTHD
	(SoHD , MaSP , SoLuong)
VALUES
	('1005','TV05','50')
INSERT INTO CTHD
	(SoHD , MaSP , SoLuong)
VALUES
	('1005','TV06','50')
INSERT INTO CTHD
	(SoHD , MaSP , SoLuong)
VALUES
	('1006','TV07','20')
INSERT INTO CTHD
	(SoHD , MaSP , SoLuong)
VALUES
	('1006','ST01','30')
INSERT INTO CTHD
	(SoHD , MaSP , SoLuong)
VALUES
	('1006','ST02','10')
INSERT INTO CTHD
	(SoHD , MaSP , SoLuong)
VALUES
	('1007','ST03','10')
INSERT INTO CTHD
	(SoHD , MaSP , SoLuong)
VALUES
	('1008','ST04','8')
INSERT INTO CTHD
	(SoHD , MaSP , SoLuong)
VALUES
	('1009','ST05','10')
INSERT INTO CTHD
	(SoHD , MaSP , SoLuong)
VALUES
	('1010','TV07','50')
INSERT INTO CTHD
	(SoHD , MaSP , SoLuong)
VALUES
	('1010','ST07','50')
INSERT INTO CTHD
	(SoHD , MaSP , SoLuong)
VALUES
	('1010','ST07','50')
INSERT INTO CTHD
	(SoHD , MaSP , SoLuong)
VALUES
	('1010','ST08','100')
INSERT INTO CTHD
	(SoHD , MaSP , SoLuong)
VALUES
	('1010','TV03','100')
INSERT INTO CTHD
	(SoHD , MaSP , SoLuong)
VALUES
	('1011','ST06','50')
INSERT INTO CTHD
	(SoHD , MaSP , SoLuong)
VALUES
	('1012','ST07','3')
INSERT INTO CTHD
	(SoHD , MaSP , SoLuong)
VALUES
	('1013','ST08','5')
INSERT INTO CTHD
	(SoHD , MaSP , SoLuong)
VALUES
	('1014','BC02','80')
INSERT INTO CTHD
	(SoHD , MaSP , SoLuong)
VALUES
	('1014','BB02','100')
INSERT INTO CTHD
	(SoHD , MaSP , SoLuong)
VALUES
	('1014','BC04','60')
INSERT INTO CTHD
	(SoHD , MaSP , SoLuong)
VALUES
	('1014','BB01','50')
INSERT INTO CTHD
	(SoHD , MaSP , SoLuong)
VALUES
	('1015','BB03','7')
INSERT INTO CTHD
	(SoHD , MaSP , SoLuong)
VALUES
	('1016','TV01','5')
INSERT INTO CTHD
	(SoHD , MaSP , SoLuong)
VALUES
	('1017','TV02','1')
INSERT INTO CTHD
	(SoHD , MaSP , SoLuong)
VALUES
	('1017','TV03','1')
INSERT INTO CTHD
	(SoHD , MaSP , SoLuong)
VALUES
	('1017','TB04','5')
INSERT INTO CTHD
	(SoHD , MaSP , SoLuong)
VALUES
	('1018','ST04','5')
INSERT INTO CTHD
	(SoHD , MaSP , SoLuong)
VALUES
	('1019','ST05','1')
INSERT INTO CTHD
	(SoHD , MaSP , SoLuong)
VALUES
	('1023','ST04','6')