-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathSQLQuery1.sql
53 lines (47 loc) · 2.61 KB
/
SQLQuery1.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
INSERT TUYEN VALUES('TU001',N'TP.HCM',N'ĐÀ NẴNG');
INSERT TUYEN VALUES('TU002',N'TP.HCM',N'QUẢNG TRỊ');
INSERT TUYEN VALUES('TU003',N'TP.HCM',N'ĐÀ LẠT');
INSERT TUYEN VALUES('TU004',N'TP.HCM',N'HUẾ');
INSERT TUYEN VALUES('TU005',N'TP.HCM',N'QUY NHƠN');
INSERT TUYEN VALUES('TU006',N'TP.HCM',N'SAPA');
INSERT TUYEN VALUES('TU007',N'TP.HCM',N'HÀ NỘI');
INSERT TUYEN VALUES('TU008',N'GIA LAI',N'TP.HCM');
INSERT TUYEN VALUES('TU009',N'GIA LAI',N'HÀ NỘI');
INSERT TUYEN VALUES('TU010',N'HÀ NỘI',N'TP.HCM');
INSERT XE VALUES('XE001','74K036');
INSERT XE VALUES('XE002','60H361');
INSERT XE VALUES('XE003','50V936');
INSERT XE VALUES('XE004','44D006');
INSERT XE VALUES('XE005','34N001');
INSERT XE VALUES('XE006','50P546');
INSERT XE VALUES('XE007','88M336');
INSERT GHE VALUES('GHE001',1,'XE001');
INSERT GHE VALUES('GHE002',2,'XE001');
INSERT GHE VALUES('GHE003',3,'XE001');
INSERT GHE VALUES('GHE004',4,'XE001');
INSERT GHE VALUES('GHE005',5,'XE001');
INSERT GHE VALUES('GHE006',6,'XE001');
INSERT GHE VALUES('GHE007',7,'XE001');
INSERT LOTRINH VALUES('LT001','XE001','TU001','2013-08-30 19:05:00',200000);
INSERT LOTRINH VALUES('LT002','XE002','TU003','2020-09-01 04:05:00',100000);
INSERT LOTRINH VALUES('LT003','XE003','TU005','2020-04-15 11:00:00',250000);
INSERT LOTRINH VALUES('LT004','XE001','TU004','2020-11-30 09:00:00',300000);
INSERT LOTRINH VALUES('LT005','XE002','TU001','2020-06-20 12:15:00',250000);
INSERT LOTRINH VALUES('LT006','XE003','TU002','2020-08-31 14:30:00',200000);
INSERT LOTRINH VALUES('LT007','XE004','TU007','2020-08-31 14:30:00',260000);
INSERT LOTRINH VALUES('LT008','XE005','TU009','2020-08-31 14:30:00',270000);
INSERT KHACHHANG VALUES('KH001',N'THÙY NHI','09453654','nhi@gmail.com',N'GIA LAI');
INSERT KHACHHANG VALUES('KH002',N'ĐỨC ANH','09473424','anh@gmail.com',N'ĐỒNG NAI');
INSERT KHACHHANG VALUES('KH003',N'THANH VÂN','091243654','van@gmail.com',N'QUẢNG TRỊ');
INSERT KHACHHANG VALUES('KH004',N'BẢO AN','09453134','an@gmail.com',N'TP.HCM');
INSERT KHACHHANG VALUES('KH005',N'KIỀU MY','09447654','my@gmail.com',N'ĐỒNG THÁP');
INSERT KHACHHANG VALUES('KH006',N'NGỌC DUNG','0942654','dung@gmail.com',N'BẾN TRE');
INSERT VE VALUES('VE001','GHE001','LT001','KH001');
INSERT VE VALUES('VE002','GHE002','LT001','KH001');
INSERT VE VALUES('VE003','GHE003','LT001','KH002');
INSERT VE VALUES('VE004','GHE004','LT001','KH002');
INSERT VE VALUES('VE005','GHE005','LT001','KH003');
INSERT VE VALUES('VE006','GHE001','LT001','KH003');
INSERT VE VALUES('VE007','GHE002','LT001','KH004');
INSERT VE VALUES('VE008','GHE003','LT001','KH004');