WEBVTT

00:00.350 --> 00:03.990
And just let children to some data are values that is update our table.

00:04.290 --> 00:05.540
So this quite simple.

00:05.790 --> 00:07.970
We have to focus on a deep query.

00:08.070 --> 00:10.920
And also we need to barometers here.

00:10.920 --> 00:14.550
The first one will be which particular value I need to date.

00:14.760 --> 00:19.590
So if I want to date first value that is I have a unique I.T. that is one.

00:19.590 --> 00:23.380
And if I need to update the second door I have a unique idea that is true.

00:23.520 --> 00:27.560
So my unique I.D. my mapping thing would be done with my I.D..

00:27.630 --> 00:33.290
The second thing is what I need to update I need to update my name my salary department.

00:33.510 --> 00:34.790
So what I need to be.

00:34.990 --> 00:40.710
So suppose we need to update this department for this particular employee with the help of this I.T..

00:40.770 --> 00:42.770
So this is unique for every employer.

00:43.110 --> 00:44.940
And we need to update their department.

00:45.510 --> 00:46.520
So let us do that.

00:46.530 --> 00:54.090
Let me comment out my INSERT query now use my car set object and head all I need to pass out update

00:54.390 --> 01:00.720
my table name then set what column I need to update that is simple they need to update my department

01:00.870 --> 01:07.550
equal to that particular new value that I'm modifying and then I need to map that unique IP.

01:07.650 --> 01:09.270
So I would be using there.

01:09.480 --> 01:12.610
And then I need to just give that particular variety.

01:12.730 --> 01:13.620
This looks fine.

01:13.790 --> 01:16.940
And if I'm updating I have to commit some changes.

01:17.040 --> 01:20.400
So I just need to use my connection object and then comment.

01:20.730 --> 01:22.180
Yeah that's totally fine.

01:22.230 --> 01:23.760
Let me run this one.

01:23.760 --> 01:24.810
Have you got any ETA.

01:24.830 --> 01:28.740
Let me visit my database and let me refresh this one.

01:29.610 --> 01:31.530
Yeah I got my hat on.

01:31.560 --> 01:37.020
So this looks fine unhedged I have updated my bar declared war with a new value.

01:37.200 --> 01:39.310
So this is working fine for us.

01:39.320 --> 01:45.180
So in the next lecture let us use select as well as fetch all straight men to get our data that we have

01:45.180 --> 01:47.150
already stored in our database.

01:47.160 --> 01:48.750
I hope this lecture was helpful.

01:48.750 --> 01:49.950
See you in the next one.