1
00:00:00,510 --> 00:00:01,790
Welcome back.

2
00:00:02,510 --> 00:00:05,290
Now we have our tables here.

3
00:00:05,420 --> 00:00:16,960
But what if we wanted to delete something. Let's say Sally decides to- let's try that again.

4
00:00:18,770 --> 00:00:25,640
Let's say Sally wants to just not be part of this app anymore and she's going to remove her user. Well

5
00:00:25,850 --> 00:00:27,090
she can send a request.

6
00:00:27,110 --> 00:00:37,100
And on the back end we can simply do delete the table name users and then we say which user. Well we

7
00:00:37,150 --> 00:00:46,790
use the WHERE key word and here say name equals 'Sally', press enter.

8
00:00:46,890 --> 00:00:55,690
And with delete, we actually have to do delete FROM so delete FROM users WHERE name equals Sally.

9
00:00:56,370 --> 00:00:57,620
And we have one delete.

10
00:00:57,810 --> 00:01:05,420
If I do select star from users there you go,

11
00:01:05,420 --> 00:01:10,120
Sally's gone. All right I think we're done with this example.

12
00:01:10,280 --> 00:01:12,130
Let's delete these tables.

13
00:01:12,140 --> 00:01:22,570
How can we do that. We can just DROP table and say login, login has been removed and then DROP table

14
00:01:25,190 --> 00:01:28,660
users. If I

15
00:01:28,770 --> 00:01:31,410
look at what tables we have,

16
00:01:31,860 --> 00:01:36,330
we have no relations, no tables.

17
00:01:36,350 --> 00:01:37,400
All right.

18
00:01:37,730 --> 00:01:39,450
Good job getting this far.

19
00:01:39,470 --> 00:01:40,450
I'll see you in the next video, bye-bye.