Insert Data

gistfile1.sql

INSERT INTO category (category_id,"name") VALUES (1,'Electronics');
INSERT INTO category (category_id,"name") VALUES (2,'Car');
INSERT INTO category (category_id,"name") VALUES (3,'Computer');
INSERT INTO category (category_id,"name") VALUES (4,'Handphone');

INSERT INTO product ("name",description,price,expireddate,category_id) VALUES ('Infocus','',399,'2014-09-04',1);
INSERT INTO product ("name",description,price,expireddate,category_id) VALUES ('Lenovo','',399,'2015-01-04',3);
INSERT INTO product ("name",description,price,expireddate,category_id) VALUES ('Honda','',399,'2016-08-04',2);
INSERT INTO product ("name",description,price,expireddate,category_id) VALUES ('HTC EVO 4G','',399,'2013-02-04',4);
INSERT INTO product ("name",description,price,expireddate,category_id) VALUES ('Fujitsu','',399,'2014-06-04',3);
INSERT INTO product ("name",description,price,expireddate,category_id) VALUES ('Acer Aspire','',399,'2012-04-04',3);