8/10 Lesson 2nd Command Delete rows with NULL not working


#1



Replace this line with your code.


#2

Hello.
Code:
DELETE FROM celebs WHERE twitter_handle IS NULL;

SELECT * FROM celebs;

won't let me get through. I've tried without the select query, but the same issue occurs.
Any ideas?
Or it's something wrong with the interface?

Thanks!


#3

It's not working for me either.


#4

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

DELETE FROM celebs WHERE twitter_handle IS NULL;

SELECT * FROM celebs;

if you write this it should pass


#5

Doesnt work for me either ..any solution ?


#6

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

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

This makes it pass.


#7

Thanks @skeletonz1 Why is it not working previously any idea?


#8

Thanks @skeletonz1 . When I just put delete it wont pass, need to get and print the result set as well. Your solution worked for me.


#9

It;s basically what @javaace81760 said, they just wanted us to display the table again, so they could actually make sure what was outputted was correct.


#10

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