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

how to answer this questions?

Now we're using a database from a smartphone. It has a phone_book table. It has the columns id, first_name, last_name and phone. Update all contacts to have the first name of "Mystery" and last name of "Person".

UPDATE phone_book SET first_name = "Mystery" AND last_name = "Person" WHERE first_name = NULL and last_name = NULL

1 Answer

Angela Visnesky
Angela Visnesky
20,927 Points

Hi Collega! You're really close. You need to updat all of the contacts, not specific ones. The keyword AND is used in a conditional that you don't need. Your code should look similar to:

UPDATE phone_book SET first_name = "Mystery", last_name = "Person" ;

I hope this helps!