-
Notifications
You must be signed in to change notification settings - Fork 0
/
supplier.sql
29 lines (24 loc) · 1.33 KB
/
supplier.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
SELECT * FROM finalproject.supplier;
describe supplier;
delete from supplier;
INSERT INTO supplier VALUES('S005','NMac','SMAc',1234567890);
INSERT INTO supplier VALUES('S002','NLen','SLen',765676678);
INSERT INTO supplier VALUES('S003','NHp','SHp',198778009);
INSERT INTO supplier VALUES('S004','NDel','SDel',545455454);
INSERT INTO supplier VALUES('S001','NMac','SMAc',1234534890);
INSERT INTO supplier VALUES('S006','NLen','SLen',765633678);
INSERT INTO supplier VALUES('S007','NHp','SHp',19782339);
INSERT INTO supplier VALUES('S008','NDel','SDel',235455454);
INSERT INTO supplier VALUES('S009','NMac','SMAc',334567890);
INSERT INTO supplier VALUES('S010','NLen','SLen',723676678);
INSERT INTO supplier VALUES('S011','NHp','SHp',192378009);
INSERT INTO supplier VALUES('S012','NDel','SDel',445455454);
INSERT INTO supplier VALUES('S013','NMac','SMAc',434567890);
INSERT INTO supplier VALUES('S014','NLen','SLen',765676678);
INSERT INTO supplier VALUES('S015','NHp','SHp',194478009);
INSERT INTO supplier VALUES('S016','NDel','SDel',545455454);
INSERT INTO supplier VALUES('S017','NMac','SMAc',1234567890);
INSERT INTO supplier VALUES('S018','NLen','SLen',565676678);
INSERT INTO supplier VALUES('S019','NHp','SHp',198745009);
INSERT INTO supplier VALUES('S020','NDel','SDel',545455454);
INSERT INTO supplier VALUES('S021','NMac','SMAc',1664567890);