1
00:00:06,070 --> 00:00:12,380
Here even so in this video we are going to learn that how you can view the data available in the database.

2
00:00:12,400 --> 00:00:19,710
So let's begin with that one vote that one again just copy this one because everything is same here.

3
00:00:19,720 --> 00:00:26,620
Just geez the sun in the view of a functioning and the execute.

4
00:00:26,620 --> 00:00:30,880
Come on with the one that we have used in the last video.

5
00:00:31,060 --> 00:00:35,550
SELECT start from data.

6
00:00:36,110 --> 00:00:39,040
We have data table in that one just deadpanned.

7
00:00:39,410 --> 00:00:41,430
So it will select all the data from that one.

8
00:00:42,110 --> 00:00:49,960
Now here I need a command with a variable set rules which will fetch all the data from rolls.

9
00:00:50,150 --> 00:00:55,290
So I will point my cursor to fetch or so fetch.

10
00:00:55,290 --> 00:00:57,210
Or so by using the sun.

11
00:00:57,230 --> 00:01:02,850
It was stored all the various values available in that particular role in this variable rules.

12
00:01:03,140 --> 00:01:06,260
And this is a view function that is giving us the output.

13
00:01:06,650 --> 00:01:13,850
So I should just return those here the right advice I will not get output.

14
00:01:13,850 --> 00:01:24,290
Now just print this one print we'll save and run it here.

15
00:01:24,850 --> 00:01:30,350
I turned three DeVito b y labial.

16
00:01:30,400 --> 00:01:38,950
So here we get a list containing tuples in which we have three values buggy Buggy and bugger hero that

17
00:01:38,950 --> 00:01:41,080
we have added in our database.

18
00:01:41,110 --> 00:01:43,870
So this is how you can get the data available there.

19
00:01:45,170 --> 00:01:58,090
Now for that part just copy this one and change the address this one.

20
00:01:58,280 --> 00:01:59,240
There we go.

21
00:01:59,240 --> 00:02:04,790
Now if you run this one we get the data from that 1 1.

22
00:02:04,800 --> 00:02:06,780
Bugger off with hundred marks.

23
00:02:06,780 --> 00:02:11,330
Then the same if we remember we have to deal there we have the same two.

24
00:02:11,340 --> 00:02:12,900
Then we have this super.

25
00:02:13,770 --> 00:02:19,260
So here we have super so high as you can see here this part is very easy because once everything is

26
00:02:19,260 --> 00:02:22,940
set up then there's nothing in that plan.

27
00:02:23,130 --> 00:02:25,340
So we are also done with visualizing.

28
00:02:25,710 --> 00:02:29,640
This is about this one in the next video we will learn that how you can delete data from data and by

29
00:02:29,640 --> 00:02:31,560
using the programming.

30
00:02:31,560 --> 00:02:32,430
So thanks for watching.

31
00:02:32,430 --> 00:02:33,450
See you in the next video.