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


#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

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