Database Reference
In-Depth Information
INSERT INTO EMPLOYEE
VALUES(6, 'Mary','Smith')
INSERT INTO EMPLOYEE
VALUES(7, 'Joe','Wyer')
INSERT INTO EMPLOYEE
VALUES(8, 'Bruce','Young')
— - inserting records into table PAYMENT
INSERT INTO PAYMENT
VALUES(1,'Check')
INSERT INTO PAYMENT
VALUES(2,'Master')
INSERT INTO PAYMENT
VALUES(3,'VISA')
INSERT INTO PAYMENT
VALUES(4,'American Express')
INSERT INTO PAYMENT
VALUES(5,'Discover')
— - inserting records into table PRODUCT
INSERT INTO PRODUCT
VALUES(1,'DeskTop')
INSERT INTO PRODUCT
VALUES(2,'Notebook')
INSERT INTO PRODUCT
VALUES(3,'Tablet')
INSERT INTO PRODUCT
VALUES(4,'PDA')
— - inserting records into table ITEM
INSERT INTO ITEM
VALUES(1,3,'PM 2.2 GHz','512MB','60GB','DVD-ROM/CD-RW','14.1”
swivel')
INSERT INTO ITEM
VALUES(2,2,'CM 2.0 GHz','256MB','40GB','DVD-ROM/CD-RW','15” XGA TFT')
INSERT INTO ITEM
VALUES(3,2,'PM 3.0 GHz','1024MB','100GB','DVD-RAM','15.4” WXGA TFT')
INSERT INTO ITEM
VALUES(4,2,'PM 3.6 GHz','512MB','40GB','DVD SuperMulti','7.2” WXGA TFT')
INSERT INTO ITEM
VALUES(5,2,'PM 3.6GHZ','512MB','60GB','DVD SuperMulti','12.1” XGA')
INSERT INTO ITEM
VALUES(6,2,'SD 1.5 GHz','512MB','80GB','Bluetooth 2.0','12.1” XGA')
