Code Editor

Query Results

Run a query to see results.

Database Schema

Schema undefined.


DELETE FROM celebs WHERE twitter_handle IS NULL;

The DELETE FROM statement deletes one or more rows from a table. You can use the statement when you want to delete existing records.

  1. DELETE FROM is a clause that lets you delete rows from a table.
  2. celebs is the name of the table we want to delete rows from.
  3. WHERE is a clause that lets you select which rows you want to delete. Here we want to delete all of the rows where the twitter_handle column IS NULL.
  4. IS NULL is a condition in SQL that returns true when the value is NULL and false otherwise.

In this lesson we have learned SQL statements that create, edit, and delete data. In the upcoming lessons we will learn how to use SQL to retrieve information from a database.

Let's summarize what we have learned so far.

Click Next to continue

Report a Bug
If you see a bug or any other issue with this page, please report it here.