Remove data from a table

- [Instructor] Removing a row of data from a table…can be accomplished with a delete keyword.…As with an update statement,…we need to tell the database…from where it should delete something.…It's a good idea to add a condition…to set the scope of deletion.…Otherwise, it will delete everything in the table.…Let's take a look at our table…and get rid of some records.…Alright, select star from people.…And scroll down to see some of these incomplete records…that we added before.…

Let's delete Martha White.…To do that, I'll write delete from people…where first name equals Martha…and last name equals White.…I'll run that…and I see that the query executed successfully.…I'll paint my select statement…and down here at the bottom,…I can see now that Martha White is gone.…

We can remove more than one record at a time too…with a condition that matches more than one record.…All of these new records have a null ID number,…so let's use that.…I'll change my delete statement to delete from people…where ID number is null.…Remember, null isn't zero or no.…