Hello guys, I am stuck with the same exercise.
Query:
CREATE TABLE friends (id INTEGER, name TEXT, birthday DATE);
INSERT INTO friends (id, name, birthday) Values (1, ‘Jane Doe’, ‘1993-05-19’);
Error:
near line 2: near “intofriends”: syntax error
Does any body know what is wrong with this?
Nothing insofar as that it will execute just fine in sqlite3:
sqlite> CREATE TABLE friends (id INTEGER, name TEXT, birthday DATE);
sqlite> INSERT INTO friends (id, name, birthday) Values (1, 'Jane Doe', '1993-05-19');
sqlite>
sqlite> select * from friends;
1|Jane Doe|1993-05-19
Your error message suggests that you’re missing a space, and that the code that was executed is something other than what you posted