WEBVTT

00:07.760 --> 00:13.460
In this video, we go ahead and learn how to delete a rule from a table in PostgreSQL.

00:13.760 --> 00:15.380
So we have this rule.

00:15.380 --> 00:18.500
We have a Sarah and we have another Sarah here.

00:18.500 --> 00:24.200
And how to delete maybe the ID for or ID five.

00:24.230 --> 00:26.480
So let me go ahead and delete the ID five.

00:26.480 --> 00:32.090
And if I want to do that I can actually do that from the pgadmin.

00:32.090 --> 00:36.080
And then I can also do that right from here.

00:36.230 --> 00:39.290
Now how can I delete that code here?

00:39.320 --> 00:42.200
I say delete that is a keyword.

00:42.320 --> 00:45.320
And we are going to delete from a students.

00:45.320 --> 00:52.730
And then you're going to give a where clause where I say where and I'll go ahead.

00:52.730 --> 00:57.680
And that semi-abstract ID or anything you need or where the first name is Sarah.

00:57.710 --> 01:05.630
So but if I delete the first name is Sarah, I'm going to delete both are the these two I'm going to

01:05.660 --> 01:06.800
delete both of them.

01:06.800 --> 01:14.640
So I'm going to use where this ID is equal to five because now we specify I want to delete just the

01:14.640 --> 01:18.630
fifth one and we are stress id equal to five.

01:18.630 --> 01:24.000
And go ahead and hit enter and delete one.

01:24.030 --> 01:29.100
Now if I go ahead and refresh this go ahead and check out these.

01:30.240 --> 01:32.400
Now Excel application has lost database connection.

01:32.430 --> 01:33.840
Go ahead and now.

01:36.240 --> 01:36.750
Check it out.

01:36.750 --> 01:40.230
So now we have been able to connect back.

01:40.230 --> 01:47.070
And then you can see that our the student ID five has been deleted.

01:47.070 --> 01:49.770
Another way I can also delete any of these.

01:49.770 --> 01:54.540
So this is a way you can actually delete anything from meal or table.

01:54.570 --> 01:55.260
Right.

01:55.500 --> 02:01.980
This is a we can actually delete a record from this place and that actually works fine.

02:01.980 --> 02:03.270
So go ahead and check it out.

02:03.270 --> 02:04.050
Practice with it.

02:04.050 --> 02:07.920
And if you have any question go ahead and use the question and answer section.

02:07.920 --> 02:10.800
And I'm going to get back to you as soon as possible.

02:10.830 --> 02:11.850
Thank you so much.

02:11.850 --> 02:14.820
And I'm going to see you in the next video lecture.