Welcome to the Treehouse Community
Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.
Looking to learn something new?
Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.
Start your free trialjbiscornet
22,547 PointsAndrew Chalkley makes learning simple things frustrating
At the end of the 2nd part in modifying Data with SQL there is a quiz. There are a few questions I can't find the answer to even though I feel they should be right.
This is one of the questions I am having trouble with...
Fill in the blank
UPDATE games SET platform = "Cross-Plaform" WHERE id ___ (1,4);
How is the answer not "=" when every example andrew gives for this format is "="? Is there something I'm not getting and why do I seem to run into these problems over and over again only on Andrew Chalkleys courses? Also this question too...
Next Question
Fill in the missing keywords for the following UPDATE statement.
____ cars ____ model = "Ford" ____ id = 1;
my answer
UPDATE cars SET model = "Ford" WHERE id = 1;
Again how is this not the right answer? I also tried a "," instead of "WHERE" just incase it was supposed to be updating multiple columns. I can't get either of these to work even though I'm fairly certain they should both be correct answers.
1 Answer
Steven Parker
231,269 PointsWhen you see a comparison being made with a list in parentheses, it's most likely the membership operator ("IN
") that is missing. You can't use the equality operator ("=
") with a list.
For your second question:
UPDATE cars SET model = "Ford" WHERE id = 1;
That is indeed the right answer. I tried it in the quiz and it passed.
jbiscornet
22,547 PointsThanks for the help, I was getting so frustrated when I am trying everything and keep getting a wrong answer even when they are seemingly easy questions. The answer for the first question I had was IN even though Andrew does not mention that keyword in that whole section. Also the second answer went through for some reason this time even though I tried that exact key word and in all caps many times before asking that question and kept getting a wrong answer.
Harsh s
Courses Plus Student 30 PointsHarsh s
Courses Plus Student 30 PointsFill in the missing keywords for the following UPDATE statement.
update cars set model = "Ford" where id = 1;
i think ur answer is right