Step 4!

Can anyone explain what is wrong with my code below? Doesn’t seem to change the table at all.

UPDATE friends
SET name = Jane Smith
WHERE id = 1;

Thank you!!

Link to the exercise please, so we can check what’s wrong.

try putting Jane Smith in quotes - ‘Jane Smith’

2 Likes

Hi @fndltm17,

This worked for me:

UPDATE friends
SET name = 'Jane Smith'
WHERE id = 0;

I will audit this SQL Project and add hints to all the steps this weekend!