WEBVTT

00:00.750 --> 00:01.530
And nime.

00:01.530 --> 00:02.010
OK.

00:02.010 --> 00:08.310
So we need to change that to get a connection and name and name what Ok I need to put or we hear the

00:08.310 --> 00:11.900
name that this is the particular name that we have got it from.

00:11.940 --> 00:12.280
Right.

00:12.330 --> 00:20.880
So let's say instead of getting this done let's forget about this because you have a string you already

00:20.880 --> 00:26.560
have a string that is so you already have this address as the stream we can store that address because

00:26.570 --> 00:27.650
the top will.

00:27.660 --> 00:34.310
So what I can do is instead of firing the query with the EDTA I can see it in the order of zero which

00:34.310 --> 00:36.210
is all your street right.

00:36.210 --> 00:38.590
It serves you as always string.

00:39.070 --> 00:40.530
You have the address.

00:40.530 --> 00:41.680
You can file the.

00:42.230 --> 00:42.720
Right.

00:42.900 --> 00:49.540
So let's stop also and just check up what we can do so we can close all.

00:49.590 --> 00:58.040
And we can rerun it control chip Neston and let me say in the server that we buy and let me just go

00:58.080 --> 01:09.280
to client and then we say x y z x y z at company dot com.

01:09.330 --> 01:10.870
There's still some error.

01:11.120 --> 01:16.960
Oh there's an operational error in your one twenty seven point zero point zero point one rate.

01:16.960 --> 01:17.510
OK.

01:17.510 --> 01:21.770
So let's have a look at what the error is all about.

01:21.920 --> 01:24.630
We need to recheck it once again.

01:24.740 --> 01:35.390
So we have to I have a look once again I need to we have inserted in the second one the idiot Jaro zero

01:36.140 --> 01:43.770
which is nothing but but there isn't there isn't it says this.

01:43.930 --> 01:44.380
All right.

01:44.380 --> 01:50.710
So it is a string and OK.

01:50.730 --> 01:52.470
Maybe they do not want this.

01:52.530 --> 01:54.570
Let's have a look with this.

01:54.660 --> 01:55.190
OK.

01:55.200 --> 02:03.980
So we stop boat and we close all rerun because address already has that.

02:04.080 --> 02:06.150
Maybe we'll have a look.

02:06.150 --> 02:06.660
We'll have a look.

02:06.660 --> 02:13.740
What is the conflict cost you to say OK means

02:16.210 --> 02:26.530
we can start up a client X Y Z again x y z x company dot com.

02:28.570 --> 02:37.810
So there's an upper so near dot syntax so there is there is an arrow which which makes you do it again.

02:37.810 --> 02:43.930
So what I'm going to do is we're going to check it up and tell you what the error is.

02:43.940 --> 02:47.880
OK so the error that we have.

02:48.170 --> 02:55.130
So the error that we have for we here as we can see is I haven't put this you know I have to close this

02:55.130 --> 03:01.340
bracket for values and I haven't put the semi-colon which is a part of a school query.

03:01.370 --> 03:02.200
Right.

03:02.240 --> 03:03.860
And now let's run it.

03:03.870 --> 03:08.510
So that's going to be an operational or what Tom's what they felt.

03:08.690 --> 03:08.960
Right.

03:08.960 --> 03:10.320
So let's run this up.

03:10.320 --> 03:17.020
So wait a minute I need to tie up all of these first close call.

03:17.100 --> 03:19.080
Let me run this again.

03:19.080 --> 03:21.500
So the server is running the client.

03:21.500 --> 03:31.240
Let me add one that up let's say X Y Z and let's say X Y Z at company dot com and have a look.

03:31.320 --> 03:34.600
Got a connection from client saying and x y z.

03:34.650 --> 03:38.870
So things are going fine and this has got executed right.

03:38.880 --> 03:47.940
So what we can do is we can just check with the query that if the Aquarius work fine we can always have

03:47.940 --> 03:48.530
a look.

03:48.600 --> 03:56.050
By opening up and icon prompt right we can open up Anaconda crumbed and just check up.

03:56.130 --> 03:58.720
This is there in right.

03:58.810 --> 04:01.540
Is there indeed coal in some projects.

04:01.590 --> 04:02.080
Okay.

04:02.280 --> 04:07.390
So instead of instead of going into your or you know you can you can always read it.

04:07.570 --> 04:13.880
So we're also if you remember we taught you how to read from database by saying something like this

04:13.890 --> 04:14.280
right.

04:14.280 --> 04:20.850
So instead of saying sains select star from students and this particular code we can just take two clients

04:20.850 --> 04:26.930
that DVH and just check it out like Cline's that DVH certain details.

04:26.940 --> 04:31.170
Sellick star from a database named is not clients.

04:31.260 --> 04:36.050
The database name is that people whose name is Chandra Levy and

04:39.560 --> 04:47.930
select are from clients so we can just fire this up and just check it up and we can close this where

04:47.930 --> 04:50.730
we don't need to help the gender.

04:50.740 --> 04:53.100
OK so her result.

04:53.200 --> 04:58.330
We can just print the results for now rest all of them can be closed.

04:58.450 --> 04:58.720
Right.

04:58.720 --> 05:00.160
So you can close all of these

05:03.860 --> 05:08.900
I can close all of these were are there and then there's conduct close.

05:09.010 --> 05:11.400
Great so I can just print this result for now.

05:11.470 --> 05:14.530
Instead of saying student details we didn't dare to do that.

05:14.530 --> 05:21.640
These are the client details so I'm going to run this up so no such stable clients select star from

05:21.800 --> 05:30.460
clients is our is our table clients rate.

05:30.610 --> 05:41.660
There is a table clients which is going to be chad DVH and we have created Clynes right.

05:41.660 --> 05:49.240
So we go OK so we could change your itself.

05:49.360 --> 05:51.980
That is we're going to put it over here.

05:51.980 --> 05:58.900
And so what people say is instead of saying in the stop itself what we can do is we can make him execute

05:59.550 --> 06:02.160
instead of going to that particular file.

06:02.230 --> 06:08.620
You can make him sure all the clients and start to sell the Soval who are already registered and the

06:08.620 --> 06:10.720
database Sollee created.

06:10.820 --> 06:16.170
Let's see if I make a cassette or execute select star from clients.

06:16.600 --> 06:21.320
Select star from clients.

06:23.120 --> 06:26.410
And if I do of Cazador threshold

06:29.300 --> 06:32.370
and I say this can be your result.

06:33.000 --> 06:34.580
Let me print the result.

06:34.670 --> 06:37.230
What are the results of the current database.

06:37.230 --> 06:42.260
So I'm not adding any clients I'm just fetching the database at the start itself and just printing it

06:42.260 --> 06:42.860
up.

06:42.860 --> 06:48.410
So it only tells me yo said this one already which is registered and that particular this particular

06:48.410 --> 06:52.250
address which basically means this from the same PC.

06:52.310 --> 06:52.630
Right.

06:52.630 --> 06:56.810
So if you add more you can print more.

06:56.810 --> 06:57.500
Right.

06:57.560 --> 07:00.880
You can you can always you can always do that.

07:01.150 --> 07:01.650
OK.

07:01.730 --> 07:09.580
So now if I want to be printed if I want be printed you know who all are the current number of clients

07:09.590 --> 07:11.530
whenever it gets added.

07:13.470 --> 07:18.090
You know I can just whenever a particular plane comes in I just want to print up all the clients so

07:18.090 --> 07:22.020
I could what I can do was I can just copy paste this part and just print.

07:22.060 --> 07:23.020
Right.

07:23.230 --> 07:28.540
So I can write it so we got a connection.

07:28.790 --> 07:37.350
And after seeing got a connection I can say Klein's registered I can sprint up seeing clients registered

07:41.340 --> 07:42.940
as of date.

07:43.200 --> 07:51.490
Now I can just print these three things right so I can rerun the service.

07:51.510 --> 07:57.540
So I need to close it terminate the read on it once again it say x y z.

07:57.540 --> 08:09.620
If I run a client and let me say and turn your name and I say P Q R and the so be P-Q or at gmail dot

08:09.620 --> 08:10.870
com.

08:11.300 --> 08:18.740
And so it prints all the lines as of date that's X Y Z and P Q R and it's all say I got a connection

08:18.740 --> 08:20.850
from b q r itself.

08:20.990 --> 08:21.430
OK.

08:21.500 --> 08:29.960
And so if I have more clients coming up let's say for a run one more client and let me say you know

08:30.050 --> 08:32.960
let me call it as your name.

08:32.960 --> 08:42.700
So let me say DPF and if I say TGF at that company dot com.

08:42.990 --> 08:50.040
So you have these two clients or you have now three clients register in the database and I can say if

08:50.040 --> 08:56.290
I see high it will of course be printed on DPF saying Peter said hi.

08:56.400 --> 09:01.080
So DFI also says hi and it comes your D.S. told you hi.

09:01.110 --> 09:05.100
So these are a few things that we need to understand when we think about it is if we want to access

09:05.100 --> 09:06.430
the database.

09:06.810 --> 09:12.660
You know any time later you want to you will have filed a query you can put them in the in the client

09:12.660 --> 09:13.050
task.

09:13.080 --> 09:13.490
OK.
