Yurttas/PL/DBL/mysql/F/01/00/SPJ/Suppliers-ins.sql
Revision as of 16:37, 3 November 2013 by MassBot1 (talk | contribs) (Created page with "<syntaxhighlight lang="sql" line start="1" enclose="div">→REM REM REM Suppliers-ins.sql REM REM: \. set-db.sql INSERT INTO Suppliers VALUES('S01', 'Frank', 20, 'Housto...")
1/*
2REM
3REM
4REM Suppliers-ins.sql
5REM
6REM
7*/
8
9\. set-db.sql
10
11INSERT INTO Suppliers
12 VALUES('S01', 'Frank', 20, 'Houston');
13
14INSERT INTO Suppliers
15 VALUES('S02', 'David', 20, 'Houston');
16
17INSERT INTO Suppliers
18 VALUES('S03', 'David', 30, 'Houston');
19
20INSERT INTO Suppliers
21 VALUES('S04', 'Jason', 10, 'Denver');
22
23INSERT INTO Suppliers
24 VALUES('S05', 'Richard', 30, 'Denver');
25
26 INSERT INTO Suppliers
27 VALUES('S06', 'Carlos', 20, 'Phoenix');
28
29INSERT INTO Suppliers
30 VALUES('S07', 'John', 40, 'Phoenix');
31
32INSERT INTO Suppliers
33 VALUES('S08', 'Ajay', 30, 'Detroit');