How to make this 8. Alter work?

<PLEASE USE THIS TEMPLATE TO HELP YOU CREATE A GREAT POST!>

<Below this line, add a link to the EXACT exercise that you are stuck at.>

<Below this line, in what way does your code behave incorrectly? Include ALL error messages.>

<In this course, it often helps to include a screenshot of your whole web browser – that lets everyone see what you see. If you wish to include a screenshot, add it below this line.>

<If you wish to copy/paste in your code, you can use this next section. This will allow others to copy/paste your code for testing – something that they won’t be able to do with just a screenshot.>

```

UPDATE celebs
SET twitter_handle = ‘@taylorswift13
WHERE id = 4;

SELECT * FROM celebs;
DELETE FROM celebs WHERE twitter_handle IS NULL;

When I run this code, nothing happens…

<do not remove the three backticks above>

What are the instructions? Can you make a screenshot please?

I also tried removing following line
DELETE FROM celebs WHERE twitter_handle IS NULL;

and exchnaged it with following:

Delete from celebs where twitter_handle =’ ';

without giving the expected action.

Maybe it wants you to go to the next line… like:

DELETE FROM celebs 
WHERE twitter_handle IS NULL;

I tried that too, but got the same error. nothing happens.

Insert the Delete command line on line 4, in between the first set of commands and the last one.

  1. UPDATE celebs
  2. SET twitter_handle = ‘@taylorswift13
  3. WHERE id = 4;
  4. DELETE FROM celebs WHERE twitter_handle IS NULL;
  5. SELECT * FROM celebs;
1 Like

I managed to get task 1 correct but I cant seem to figure out task 2, which is circled with yellow.

Now just move the “SELECT * FROM celebs;” down to line 5 and insert “DELETE FROM celebs WHERE twitter_handle IS NULL;” onto line 4 and then run the whole batch.

The instruction is to type the command above the select

2 Likes

LOL* thanks stupid me :stuck_out_tongue:

normally it should read just the last line but i think here it restart to read all the command from the top that’s why nothing has change…

Lol… It is not your fault… :smile:

Thnak you for your help. :slight_smile:

1 Like

Thanks I ran into the same problem.

1 Like

2 posts were split to a new topic: 8. Having the same problems and tried typing ABOVE like the suggestion