Database-Project---Level-Up-Life/customerBill.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
28
29
30
31
32
SELECT * FROM finalproject.customerBill;

delete from finalproject.customerBill;

INSERT INTO customerBill VALUES ('BChi','OChi','C002',0);
INSERT INTO customerBill VALUES ('BGee','OGee','C003',0);
INSERT INTO customerBill VALUES ('Bbpo','OApo','C004',0);
INSERT INTO customerBill VALUES ('cChi','OChi','C005',0);
INSERT INTO customerBill VALUES ('cGee','OGee','C006',0);
INSERT INTO customerBill VALUES ('dApo','OApo','C007',0);
INSERT INTO customerBill VALUES ('tthi','OChi','C002',0);
INSERT INTO customerBill VALUES ('Biee','Ogee','C007',0);

INSERT INTO customerBill VALUES ('BAee','OGee','C009',0);
INSERT INTO customerBill VALUES ('kApo','OApo','C010',0);

INSERT INTO customerBill VALUES ('kGee','OGee','C012',0);
INSERT INTO customerBill VALUES ('kLpo','OApo','C013',0);
INSERT INTO customerBill VALUES ('BLai','OChi','C014',0);
INSERT INTO customerBill VALUES ('BGQQ','OGee','C015',0);

INSERT INTO customerBill VALUES ('BCsi','OChi','C017',0);


INSERT INTO customerBill VALUES ('Bvci','OChi','C019',0);
INSERT INTO customerBill VALUES ('BAee','OGee','C009',0);
INSERT INTO customerBill VALUES ('kApo','OApo','C010',0);

INSERT INTO customerBill VALUES ('kkee','OGee','C012',0);
INSERT INTO customerBill VALUES ('llpo','OApo','C013',0);
INSERT INTO customerBill VALUES ('bbai','OChi','C014',0);
INSERT INTO customerBill VALUES ('BuQQ','OGee','C015',0);