0

The sumbit50 site only gives me credit for 7% of the assignment. I have completed all 13 sql and they work, but I must admit I checked them through PHPliteadmin in the movies.db. the queries are all correct, but I could not get the cat 1.sql | sqlite3 movies.db to print out anything which is why I checked my codes in PHPliteadmin. I have attached sqlite code for one of the exercises to show what I have done in each sql file Saw previous posts where someone had comments and removed comments and it worked. I have NO comments. I I did not use my local machine so I am checking my code via ~/pset7/movies/ $ cat 1.sql | sqlite3 movies.db ~/pset7/movies/ $ But nothing gets returned. however the code is executed in the phplitadmin as I see the new tables and they are correct.

CREATE TABLE bd_emma_stone1(birth NUMERIC); INSERT INTO bd_emma_stone1 (birth) SELECT distinct birth FROM people WHERE name == "Emma Stone";

Movies - 7% is my grade
check50 provided the below :( 2.sql produces correct result Error when executing query: too many statements at once :( 3.sql produces correct result Error when executing query: too many statements at once :( 4.sql produces correct result Error when executing query: too many statements at once :( 5.sql produces correct result Error when executing query: too many statements at once :( 6.sql produces correct result Error when executing query: too many statements at once :( 7.sql produces correct result Error when executing query: too many statements at once :( 8.sql produces correct result Error when executing query: too many statements at once :( 9.sql produces correct result Error when executing query: too many statements at once :( 10.sql produces correct result Error when executing query: too many statements at once :( 11.sql produces correct result Error when executing query: too many statements at once :( 12.sql produces correct result Error when executing query: too many statements at once :( 13.sql produces correct result Error when executing query: too many statements at once .

1 Answer 1

0

Okay, I figured out that I was not suppose to create a table--as in a SINGLE line query. I was creating a table with headings for each query--hence too many lines submitted. Once i removed the "creat table line" all my queries worked perfectly.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .