WEBVTT 00:00.920 --> 00:04.890 Know what we are going to use is we we displayed that data. 00:05.770 --> 00:08.690 Which is going to start in my database. 00:08.740 --> 00:15.560 So that database I'm going to use the brain the values on my console. 00:15.760 --> 00:19.130 So for that I will write the code here. 00:19.300 --> 00:23.890 I will write select all data off table 00:26.650 --> 00:31.940 we are going to select all the data from the table for that what we are going to use it. 00:31.950 --> 00:41.070 We will use here the select query so we use the three queries here create query insert query and select 00:41.130 --> 00:48.160 query select start from the name of the table is stored. 00:48.200 --> 00:52.610 So select start from student Opta. 00:52.660 --> 01:01.150 I'm going to use call Sargodha execute ival boss Asgill. 01:01.550 --> 01:12.240 Now I will create the data element rules cursors dog fetch all function we will use. 01:12.870 --> 01:21.630 So with the help of this we will fetch all the records from the Student table so that table is having 01:21.630 --> 01:26.500 multiple values so what we do is we will create a for loop here. 01:26.820 --> 01:38.340 We will use for there's always a very able which we have created in a rose row in rows and after that 01:38.340 --> 01:41.290 we need to use the column. 01:41.390 --> 01:47.800 And now what we are going to use is we are going to bring the roll here. 01:47.810 --> 01:50.770 So we have printed the values of the that. 01:51.140 --> 01:58.010 Now after that let's close the connection connection dark clothes statement. 01:58.040 --> 02:01.990 We will use so. 02:02.240 --> 02:05.500 Let's go to added configurations. 02:05.570 --> 02:07.110 We are going to carry. 02:07.130 --> 02:11.720 We have created a new python file name as my day Beaven. 02:11.840 --> 02:21.450 So here I will pass the name Majdi one and after that I will select the particular byte and file here 02:22.440 --> 02:33.460 the name of the byte and file we will select from here our project is example one in the example when 02:34.360 --> 02:42.240 I need to search my file byte and file that is my baby on select the August it might apply and then 02:42.240 --> 02:42.970 OK. 02:43.350 --> 02:45.690 So my day one is Friday. 02:45.780 --> 02:49.730 So let's begin with the running example. 02:49.950 --> 02:54.830 It is giving errors like calls or don't execute axil Asgill statement. 02:54.920 --> 03:01.610 Escalate the DOD operational error values 4 4 5 columns. 03:01.830 --> 03:11.720 So it is saying that we have given here the four values instead we have mentioned five values there. 03:11.730 --> 03:14.850 So for that it is generating the error. 03:15.150 --> 03:17.840 Let's try to remove the error here. 03:18.120 --> 03:24.740 First let's understand what it is saying that it is single line number two in the five in module code 03:24.820 --> 03:26.880 so don't execute as well. 03:27.210 --> 03:31.280 Line number two and default it is saying line number 25. 03:31.320 --> 03:41.280 It is saying that code Sargodha good as curial statement here what we have done is we are going to insert 03:41.310 --> 03:42.270 the queries. 03:42.450 --> 03:50.250 So we need to give here the ID because the ID value which we have defined is it is the primary key and 03:50.250 --> 03:52.680 it is auto incremented value. 03:52.800 --> 04:03.000 So we need to define here in the parameters for ID ID will be incremented by default like one to three 04:03.570 --> 04:04.630 as many records. 04:04.640 --> 04:05.990 We will insert. 04:06.120 --> 04:07.810 It will be autoincrement. 04:08.800 --> 04:11.550 So let's run this example again. 04:11.550 --> 04:15.810 Now it is giving added that line number 29. 04:15.810 --> 04:20.730 There is no such table stored. 04:20.780 --> 04:22.900 So let's check for that. 04:27.730 --> 04:34.560 Here we have use is the name of the table is to turn stored. 04:34.570 --> 04:37.100 Baby is the database name. 04:37.100 --> 04:40.230 So we have to give the same name here. 04:41.020 --> 04:45.480 Like inserting student we have given the correct name here. 04:45.520 --> 04:56.760 So likewise here in the select statement we have to give here the student so let's run this see. 04:56.970 --> 05:02.930 It has given me values like Rodney's the primary ID. 05:02.990 --> 05:10.410 I haven't sold the name after we have given here that the number is 20. 05:10.440 --> 05:12.200 The cause of it is dead. 05:12.510 --> 05:20.290 And the Mock's cord is 50 so we have inserted the values in the database. 05:20.500 --> 05:27.410 So let's read this example by changing the values here. 05:27.640 --> 05:32.470 Let's give the name here as show Ma is just 25 05:35.010 --> 05:36.460 course Z. 05:37.480 --> 05:41.490 And the Mock's Gorda saving D. 05:43.210 --> 05:53.720 So let's save the changes and the read on the project see it does change of values here. 05:55.290 --> 06:00.690 So what I'm going to do on this example again. 06:00.880 --> 06:09.890 So it has inserted the values in my database so we are going to use these. 06:10.180 --> 06:16.550 I have downloaded an application here as you like. 06:16.570 --> 06:20.710 I have downloaded the application D-B browser for as you like. 06:21.190 --> 06:25.180 So you can simply go on Google. 06:25.420 --> 06:30.680 And after that you just need to type there the day be browser for as you like. 06:30.850 --> 06:35.180 So if you want me then we can also go there. 06:35.200 --> 06:39.680 So let's type they be browser for as you like. 06:39.820 --> 06:48.070 So we will go on as colored browser tautologically and from here we will select download file here download 06:48.070 --> 06:53.070 caretake to download the full 64 bit for Windows or DXi. 06:53.290 --> 06:58.180 So just click on the DXi it were downloaded for you. 06:58.240 --> 07:04.080 And after that you can use here the window will be like this. 07:04.120 --> 07:14.430 So we are going to open that database which we have created we have given the pod here that in the equal 07:14.440 --> 07:23.580 and we are having software's in there softwares we are having day before inside the day before. 07:23.680 --> 07:27.080 I am having the stored database. 07:27.560 --> 07:31.500 Now I'm going to open this in that store database. 07:31.520 --> 07:42.100 We are having student we are having five values ID name roll number course and marks so we are having 07:42.490 --> 07:46.770 those things. 07:46.810 --> 07:55.860 So if I have one to open that lets open that particular database. 07:55.920 --> 08:03.360 So what we have done is we have created a table and after that we have used their DB browser for rescue 08:03.410 --> 08:13.100 light and we have done these queries Moxon did of course get of them. 08:13.110 --> 08:17.320 But is this primarily auto incremented. 08:17.400 --> 08:29.010 And we have done the name as very careful them but of course mocs and we have created the table saw 08:29.880 --> 08:32.940 this is the thing which we use. 08:32.970 --> 08:37.380 Similarly we can use the execute Asgill statement here. 08:37.740 --> 08:40.600 So let's right here. 08:40.680 --> 08:56.050 So let's start from student select start from Jordan and let's exiguous this so similarly we can get 08:56.050 --> 08:57.780 on the grades as well here. 08:58.650 --> 09:10.100 So let's go to that particular for the like was e here they the equal and we are having Saville's inside 09:10.110 --> 09:10.890 those offers. 09:10.920 --> 09:16.420 I'm having D-B here I am having the stored database. 09:16.700 --> 09:19.070 I'm going to get it with not. 09:19.090 --> 09:20.580 Plus plus. 09:20.650 --> 09:26.050 So are you able to see here we are having as you like for my three. 09:26.170 --> 09:34.020 Similarly we will get the name here also which we have inserted in my database. 09:34.210 --> 09:42.090 Let's see here we are having that particular values which we have used is primary key auto increment 09:42.170 --> 09:53.030 named roll number of course and Mock's now off day so are you able to see all the values which we use 09:53.530 --> 09:54.200 there. 09:54.430 --> 10:05.190 We are able to say in this particular database file which we have just created saw. 10:05.400 --> 10:13.280 These are the things which we have created and for that we have we are able to see all the changes which 10:13.280 --> 10:15.300 we have done is. 10:15.390 --> 10:22.280 So this is the thing which we have created we have created database we have created connection with 10:22.280 --> 10:23.320 their database. 10:23.420 --> 10:31.050 And after that we are able to see the database with the help of this particular D-B browser for rescue 10:31.070 --> 10:31.600 live. 10:31.820 --> 10:41.020 So we have seen here all the values which we have created for the database. 10:41.070 --> 10:41.970 Thank you for watching.