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 trial

Databases Modifying Data with SQL Updating Data in a Database Updating Data in a Database Review

jbiscornet
jbiscornet
22,547 Points
Posted by jbiscornet
jbiscornet
22,547 Points

Andrew 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.

Harsh s
Harsh s
Courses Plus Student 30 Points
Harsh s
Harsh s
Courses Plus Student 30 Points

Fill in the missing keywords for the following UPDATE statement.

update cars set model = "Ford" where id = 1;

i think ur answer is right

1 Answer

Steven Parker
Steven Parker
231,268 Points
Steven Parker
Steven Parker
231,268 Points

When 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
jbiscornet
22,547 Points
jbiscornet
jbiscornet
22,547 Points

Thanks 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.