Welcome to the Treehouse Community

The Treehouse Community is a meeting place for developers, designers, and programmers of all backgrounds and skill levels to get support. Collaborate here on code errors or bugs that you need feedback on, or asking for an extra set of eyes on your latest project. Join thousands of Treehouse students and alumni in the community today. (Note: Only Treehouse students can comment or ask questions, but non-students are welcome to browse our conversations.)

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and a supportive community. Start your free trial today.

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

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

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
217,626 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

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.