Database Reference
In-Depth Information
INSERT INTO ITEM
VALUES(7,1,'SD 1.25 GHz','256MB','40GB','DVD Combo','')
INSERT INTO ITEM
VALUES(8,2,'SD 1.5 GHz','512MB','80GB','Bluetooth 2.0','15” XGA')
INSERT INTO ITEM
VALUES(9,1,'SD Dual 2.3 GHz','512MB','250GB','16x SuperDrive DVD','')
INSERT INTO ITEM
VALUES(10,2,'AA 2.2 GHz','512MB','80GB','DVD
+
-RW','15.4” WXGA')
INSERT INTO ITEM
VALUES(11,1,'AA 3.2 GHz','1GB','200GB','DVD
+
-RW','')
INSERT INTO ITEM
VALUES(12,1,'CD 2.0 GHz','512MB','100GB','DVD-ROM/CD-RW','')
INSERT INTO ITEM
VALUES(13,4,'SS 300 MHz','56MB','','','3.5” Transflective TFT')
INSERT INTO ITEM
VALUES(14,4,'SS 400 MHz','152MB','','','3.5” Transflective TFT')
INSERT INTO ITEM
VALUES(15,1,'AA 2.6 GHz','512MB','160GB','DVD
+
-RW','')
INSERT INTO ITEM
VALUES(16,1,'CD 3.4 GHz','512MB','100GB','DVD-ROM/CD-RW','')
INSERT INTO ITEM
VALUES(17,1,'AA 3.2 GHz','1GB','250GB','DVD
+
-RW','')
INSERT INTO ITEM
VALUES(18,2,'CM 1.40 GHz','256MB','40GB','CD-RW','14.1” XGA TFT')
INSERT INTO ITEM
VALUES(19,2,'PM 1.6 GHz','256MB','40GB','DVD-ROM/CD-RW','14.1” XGA
TFT')
INSERT INTO ITEM
VALUES(20,2,'PM 1.50 GHz','512MB','40GB','DVD-ROM/CD-RW','12.1” XGA
TFT')
— - inserting records into table INVENTORY
INSERT INTO INVENTORY
VALUES(1,1,5,1500)
INSERT INTO INVENTORY
VALUES(2,1,500,1400)
INSERT INTO INVENTORY
VALUES(3,2,2,799)
INSERT INTO INVENTORY
VALUES(4,2,454,749)
INSERT INTO INVENTORY
VALUES(5,3,12,1799)
