-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathdata.sql
More file actions
6 lines (6 loc) · 782 Bytes
/
Copy pathdata.sql
File metadata and controls
6 lines (6 loc) · 782 Bytes
1
2
3
4
5
6
-- JPA automatically loads a file called data.sql if it exists and runs it against the DB
INSERT INTO PRODUCT (id, name, description, details, quantity, price) VALUES (1, 'Echo Dot','(2nd Generation) - Black','',10,92.50)
INSERT INTO PRODUCT (id, name, description, details, quantity, price) VALUES (2, 'Anker 3ft / 0.9m Nylon Braided','Tangle-Free Micro USB Cable','ss',20,9.99)
INSERT INTO PRODUCT (id, name, description, details, quantity, price) VALUES (3, 'JVC HAFX8R Headphone','Riptidz, In-Ear','ss',30,69.99)
INSERT INTO PRODUCT (id, name, description, details, quantity, price) VALUES (4, 'VTech CS6114 DECT 6.0','Riptidz, In-Ear','ss',40,32.50)
INSERT INTO PRODUCT (id, name, description, details, quantity, price) VALUES (5, 'NOKIA OEM BL-5J','Cell Phone','ss',50,895.00)