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
Alex Fleming
1,044 PointsReview questions, stuck on one particular question and keep getting it wrong? Figured it should of been NULL?
Finish the following statement to replace NULL values with the value of "Cross-Platform".
UPDATE games SET platform = "Cross-Plaform" WHERE id = _______________ (1,4);
3 Answers
Steven Parker
231,236 PointsThe question had no "=" before the blank.
You must have accidentally added it while copying the question. The actual question was:
UPDATE games SET platform = "Cross-Platorm" WHERE id _____ (1,4);
So the question is looking for the operator which would check if id was either one of the two values in parentheses. Hint: it's a word, not a symbol.
Also, you should be aware that you cannot test for NULL using an equality ("="). To test for NULL you would use the identity operator ("IS").
Brenda Krafft
18,036 PointsThe code is trying to say:
Update the games table, by setting the platform field to "Cross-Platform" (you are missing a "t" there) where the id IS either 1 or 4.
So they are looking for an id IN the set of (1, 4).
Steven Parker
231,236 PointsThe missing "t" is actually how the question is shown in the quiz.
But since you only need to supply what goes in the blank, it doesn't affect the outcome.
HIDAYATULLAH ARGHANDABI
21,058 Pointsin IS THE TRUE ANSWER