Welcome to the Treehouse Community
Looking to learn something new?
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
Angela Visnesky20,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!