How to make this 8. Alter work?

#1 



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..

#2

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

#3

screenshot.PNG1592x682 61.7 KB

#4

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.

#5

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

DELETE FROM celebs 
WHERE twitter_handle IS NULL;
#6

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

#7

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;

#8

screenshot.PNG1583x762 90.4 KB

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

#9

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.

#10

The instruction is to type the command above the select...

#11

LOL* thanks stupid me :stuck_out_tongue:

#12

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..

#13

Lol.. It is not your fault.. :smile:

#14

Thnak you for your help. :slight_smile:

#15

Thanks I ran into the same problem.

#16

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

#17