IN sql lesson 8 out of 10 there is a problem


#1



Replace this line with your code.


#2

can you please post your code here and tell us what's the problem?


#3

If you have a problem in the second instruction, try to put the DELETE FROM command before the SELECT command in the code.
I made the same mistake.


#4

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

SELECT * FROM celebs;

DELETE FROM celebs WHERE twitter_handle
IS NULL;


#5

I have the same problem


#6

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

SELECT * FROM celebs;

DELETE FROM celebs WHERE twitter_handle
IS NULL;


#7

I think the DELETE FROM .... needs to go above the SELECT * FROM....


#8

Thanks for this answer. I had just reported the page as a bug, since (as you know) this solution is not intuitive. one has to READ the problem CAREFULLY. Instead of quickly, as I did. LOL


#9

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.