I'd like to know how to resolve an oh noes error in my project
how do I fix the
Oh, noes!
There's a syntax error near VALUES. Are you missing a parenthesis?
in
Project: Design a store database
this is everything in my SQL
CREATE TABLE store_items_for_eletronic_store (id INTEGER PRIMARY KEY, name TEXT, price INTEGER, aisle INTEGER);
INSERT INTO VALUES (1,"phones" ,100 ;
INSERT INTO VALUES (2,"computers"1000 ;
INSERT INTO VALUES (3,"tables",50;
INSERT INTO VALUES (4,"smart_pencils",25 ;
INSERT INTO VALUES ;
INSERT INTO VALUES ;
SELECT * FROM store_items(name) ;
INSERT INTO VALUES (1,"phones" ,100 ;
INSERT INTO VALUES (2,"computers"1000 ;
INSERT INTO VALUES (3,"tables",50;
INSERT INTO VALUES (4,"smart_pencils",25 ;
INSERT INTO VALUES ;
INSERT INTO VALUES ;
SELECT * FROM store_items(name) ;
and it appears blank
Please sign in to leave a comment.