Database-Project---Level-Up-Life/supplierPurchaseStatus.sql at master · krisha01/Database-Project---Level-Up-Life · GitHub

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
SELECT * FROM finalproject.supplierPurchaseStatus;

INSERT INTO supplierPurchaseStatus VALUES ('Spu1','S001','Initial');
INSERT INTO supplierPurchaseStatus VALUES ('PDel','S004','Initial');
INSERT INTO supplierPurchaseStatus VALUES ('PHp','S003','Initial');
INSERT INTO supplierPurchaseStatus VALUES ('PLen','S002','Initial');


INSERT INTO supplierPurchaseStatus VALUES ('Sbu1','S001','Initial');
INSERT INTO supplierPurchaseStatus VALUES ('Ppel','S004','Initial');
INSERT INTO supplierPurchaseStatus VALUES ('jHp','S003','Initial');
INSERT INTO supplierPurchaseStatus VALUES ('lLen','S002','Initial');

INSERT INTO supplierPurchaseStatus VALUES ('ssu1','S001','Initial');
INSERT INTO supplierPurchaseStatus VALUES ('ddel','S004','Initial');
INSERT INTO supplierPurchaseStatus VALUES ('hhp','S003','Initial');
INSERT INTO supplierPurchaseStatus VALUES ('del','S002','Initial');

INSERT INTO supplierPurchaseStatus VALUES ('win1','S001','Initial');
INSERT INTO supplierPurchaseStatus VALUES ('acer','S004','Initial');
INSERT INTO supplierPurchaseStatus VALUES ('Hp','S003','Initial');
INSERT INTO supplierPurchaseStatus VALUES ('iuen','S002','Initial');

INSERT INTO supplierPurchaseStatus VALUES ('hhu1','S001','Initial');
INSERT INTO supplierPurchaseStatus VALUES ('mmel','S004','Initial');
INSERT INTO supplierPurchaseStatus VALUES ('mnp','S003','Initial');
INSERT INTO supplierPurchaseStatus VALUES ('bven','S002','Initial');