Welcome to the Treehouse Community
Looking to learn something new?
INSERT INTO CONCERTS VALUES (10, ‘2018-03-22’, ‘Vancouver’, ‘BC’, ‘BC Place’, ‘Canada’); produces error
Error: unrecognized token: "22’" Why? my code is the same as in the video - https://teamtreehouse.com/library/altering-tables-2
This is regarding altering tables. I have run into so many problems with this course where I follow EXACTLY what the instructor says and it does not work.
What am I doing wrong?
Thanks for your help - I searched prior questions and could not find anything about this error. I also looked on line and could not find an answer I understood.
I think I see part of the problem. The data type for ID in the CONCERTS table is INTEGER when it should be SMALLINT. I don't know how that happened and don't know how to change it. I guess I will be doing more research, but would appreciate any help I could get. SQL Lite is not very friendly and I don't know why anybody would use it.
I figured it out. For some reason, the single quotes around the values weren't actually single quotes, but were - I don't know how to describe this - right side up and upside down single quotes, if that makes any sense. I have seen this before and don't know how it happens. I changed them to single quotes and it worked. BTW, the video says this query is in the Teacher's notes for this video, but it's not.