Welcome back.
Now we have our tables here.
But what if we wanted to delete something. Let's say Sally decides to- let's try that again.
Let's say Sally wants to just not be part of this app anymore and she's going to remove her user. Well
she can send a request.
And on the back end we can simply do delete the table name users and then we say which user. Well we
use the WHERE key word and here say name equals 'Sally', press enter.
And with delete, we actually have to do delete FROM so delete FROM users WHERE name equals Sally.
And we have one delete.
If I do select star from users there you go,
Sally's gone. All right I think we're done with this example.
Let's delete these tables.
How can we do that. We can just DROP table and say login, login has been removed and then DROP table
users. If I
look at what tables we have,
we have no relations, no tables.
All right.
Good job getting this far.
I'll see you in the next video, bye-bye.