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

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

```

Replace this line with your code.

<do not remove the three backticks above>

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!

It’s not working for me either.

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

1 Like

Doesnt work for me either …any solution ?

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

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

This makes it pass.

1 Like

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

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.

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.

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