1
00:00:00,060 --> 00:00:07,360
Because in this, we will be seeing hope of them, our database, they send information.

2
00:00:07,650 --> 00:00:08,790
So let's get started.

3
00:00:09,030 --> 00:00:13,230
So here we can see there is a for information schemata tables.

4
00:00:19,370 --> 00:00:22,760
So let me get the information from the.

5
00:00:27,300 --> 00:00:34,410
So it released all the tables names, so you can see there is so much of information that's come up

6
00:00:34,620 --> 00:00:37,410
and see the scheme of this.

7
00:00:43,010 --> 00:00:50,300
So you can see they will catalog this one and it was Kimock, so Information's Kiwan, so which schema

8
00:00:51,230 --> 00:00:53,120
these papers belong to?

9
00:00:53,120 --> 00:00:53,720
And they were.

10
00:00:54,230 --> 00:00:56,990
So we have this committee will name Pavlovsky.

11
00:00:57,310 --> 00:01:06,650
OK, so what you can do is first you can find a number of tables and in those tables you need to retrieve

12
00:01:06,650 --> 00:01:07,700
the are the columns.

13
00:01:08,090 --> 00:01:12,410
You can see information schema dot columns where table names that they were.

14
00:01:13,580 --> 00:01:15,080
So let's go out and do that.

15
00:01:15,410 --> 00:01:19,980
Let's see how we can reach this one next to the.

16
00:01:43,360 --> 00:01:50,050
So Tricorn, guess we don't know that category promontories be prone to escorting them, so let's call

17
00:01:50,050 --> 00:01:55,510
police and let's go to this one, Firefox's 2.0 you already quote.

18
00:01:56,620 --> 00:02:03,000
So let me find a number of columns in those categories.

19
00:02:03,610 --> 00:02:05,710
So, of course, there are two columns.

20
00:02:06,220 --> 00:02:07,810
It will try for three columns.

21
00:02:07,960 --> 00:02:10,330
So there are only two columns.

22
00:02:11,830 --> 00:02:14,110
OK, since we know there are two columns.

23
00:02:15,070 --> 00:02:15,970
Union Serag.

24
00:02:22,800 --> 00:02:27,270
So there is urgency for Mr. is springtime.

25
00:02:30,960 --> 00:02:31,410
No.

26
00:02:34,170 --> 00:02:34,950
And.

27
00:02:44,550 --> 00:02:52,990
You can also put the here and you should see the B here, so that means two columns springtime.

28
00:02:53,100 --> 00:02:54,810
So that's more than enough.

29
00:02:57,190 --> 00:03:05,460
I know we need to select table name, right, because we know that in that schema, we have this table

30
00:03:05,460 --> 00:03:13,600
on the table name, come on, all from information as that tables.

31
00:03:15,620 --> 00:03:21,730
And he didn't know you can see these are the tables, so you can dump using the for loop in Python,

32
00:03:22,130 --> 00:03:24,670
so it's we'll see about Python later.

33
00:03:25,790 --> 00:03:28,810
So these are the are the tables in the database.

34
00:03:34,150 --> 00:03:42,230
So what they're asking is that easy users and so this is the database that shows the credentials.

35
00:03:42,520 --> 00:03:43,630
So let's copy this.

36
00:03:50,400 --> 00:04:06,240
So that column not name commander from infa mission schema, not columns where they will name you this

37
00:04:06,240 --> 00:04:06,510
one.

38
00:04:10,540 --> 00:04:18,340
And I don't know, you can see all the columns, username this one and the password, so these two are

39
00:04:18,340 --> 00:04:18,970
good columns.

40
00:04:28,590 --> 00:04:29,940
Sort of Mr here.

41
00:04:36,840 --> 00:04:39,000
So we need to get this from this.

42
00:04:44,880 --> 00:04:45,510
From.

43
00:04:48,750 --> 00:04:49,980
So what is the username?

44
00:04:53,580 --> 00:04:54,990
So what is the table now?

45
00:04:55,560 --> 00:04:56,040
This one?

46
00:05:09,320 --> 00:05:09,770
From.

47
00:05:11,310 --> 00:05:20,820
This Dobrynin copy here, this so you can see we got the credentials Viña administrator, so you can

48
00:05:20,820 --> 00:05:26,820
copy this one and go to my account login with that mashaba credentials.

49
00:05:31,630 --> 00:05:39,680
So it sounds like in some cases you need to set up the scheme or that they were there.

50
00:05:39,790 --> 00:05:41,740
So how you would do this is.

51
00:05:48,150 --> 00:05:48,530
So.

52
00:05:51,350 --> 00:05:57,530
So there was Quima, so this will be a rare case where you need to Kemar.

53
00:06:00,820 --> 00:06:01,630
Whatever name.

54
00:06:03,760 --> 00:06:10,380
From information schema that not was.

55
00:06:14,010 --> 00:06:19,760
So the first one is the ski, one second one is the table now search for you on the school.

56
00:06:20,040 --> 00:06:24,850
So public is the ski mask and this one is the table.

57
00:06:28,590 --> 00:06:35,430
OK, so from inside of users, so you can say, I probably could.

58
00:06:37,010 --> 00:06:39,870
Not this table, so we get the same result.

59
00:06:40,100 --> 00:06:48,160
So I guess if a normal deboning fails, you can try the schemata to win it.

60
00:06:48,350 --> 00:06:49,900
So it will be very easy one.

61
00:06:53,220 --> 00:06:56,140
So let's go over and see for the record.

62
00:06:56,370 --> 00:07:01,200
So this will be more similar, except only this infection's pool.

63
00:07:01,270 --> 00:07:08,450
So Pashtunistan, the tables are on the roofs and in the stables, you will contain some information.

64
00:07:08,670 --> 00:07:15,630
And in that we send our columns, our columns with the table is goes to our dessert table.

65
00:07:16,020 --> 00:07:22,680
OK, so we show you how to find the juicy information from those tables.

66
00:07:48,730 --> 00:07:49,020
Well.

67
00:08:18,920 --> 00:08:24,860
So let's click on anything that's copy and go to this one, Firefox.

68
00:08:26,690 --> 00:08:34,850
So, as usual, let's find the columns starting with the second column, so we have this order, so

69
00:08:34,850 --> 00:08:38,330
that means there are two columns with sort of three.

70
00:08:39,440 --> 00:08:41,420
So there are only two columns.

71
00:08:41,900 --> 00:08:47,250
So in those terms, we need to specify which one retains those type.

72
00:08:50,280 --> 00:08:58,070
So remember, this is the Oracle database, right, not from the original associated with our version,

73
00:08:58,800 --> 00:09:00,400
so the first one is string.

74
00:09:07,440 --> 00:09:09,320
So the second one is also sitting down.

75
00:09:09,410 --> 00:09:10,880
So it's.

76
00:09:17,320 --> 00:09:29,480
So what we have is there is result was already our articles go to this hope center.

77
00:09:38,470 --> 00:09:45,270
So you can see this is the cognizable Karamzin, Mr Debnam crushed on empty business.

78
00:09:46,750 --> 00:09:49,090
So now we can use the table.

79
00:09:49,900 --> 00:09:55,450
So let's go and see table nul from.

80
00:09:55,870 --> 00:10:00,720
So which one are tables, right.

81
00:10:02,610 --> 00:10:05,540
So you can see we got the ah, the was.

82
00:10:07,190 --> 00:10:15,950
Now, the search for you this underscore, so this is the day where we have the credentials.

83
00:10:30,030 --> 00:10:36,530
So what they're telling us to find the quorums using these are condoms, right?

84
00:10:36,570 --> 00:10:39,450
There are seven condoms.

85
00:10:40,570 --> 00:10:48,280
So in order to build this connection properly and need where you need to know what the are the default

86
00:10:48,790 --> 00:10:53,880
like these databases and there was so here we have the table and the column.

87
00:10:54,310 --> 00:11:04,480
So there will be more than enough third column on the school name, not from our two columns.

88
00:11:06,340 --> 00:11:06,910
And then.

89
00:11:10,130 --> 00:11:15,700
OK, sorry, we need to specify where terrible name Zegas to.

90
00:11:19,130 --> 00:11:22,200
This one uses front and center.

91
00:11:23,630 --> 00:11:29,120
Now we got the two columns, password one and the username one.

92
00:11:36,810 --> 00:11:42,560
So copy this so you can also put the user name first on the source.

93
00:11:42,960 --> 00:11:52,380
So the order does not matter in this case, it's password and username from which they will this users

94
00:11:52,380 --> 00:11:52,740
from.

95
00:11:55,820 --> 00:12:01,670
And no, he didn't know you got the credentials, admission of this so-called.

96
00:12:10,030 --> 00:12:16,950
So these are the successful credentials, so you can see this is very simple to operate using a patent.

97
00:12:17,260 --> 00:12:23,290
So I'm not going to explain the code now because it took me nearly two days to write this.

98
00:12:24,610 --> 00:12:26,150
So I will just explain the code.

99
00:12:27,610 --> 00:12:29,360
So this format is good.

100
00:12:30,520 --> 00:12:34,840
So this function normally is it takes the user and number of forums.

101
00:12:35,050 --> 00:12:41,310
And in those columns I have already defined the command using the previous functions, using the columns.

102
00:12:41,950 --> 00:12:47,760
So here I am passing the first information.

103
00:12:47,830 --> 00:12:50,230
So whenever you type normally gives.

104
00:12:50,680 --> 00:12:53,080
So this will be the our best page.

105
00:12:53,380 --> 00:12:58,360
So whatever we are selecting the information that will be added to this particular page.

106
00:12:58,630 --> 00:13:05,350
So what I can do is I can take the space page and I can take the result page.

107
00:13:05,350 --> 00:13:08,120
After this connection, I can make the discussion.

108
00:13:08,380 --> 00:13:11,530
So we give those which are unique, each of the different ones.

109
00:13:12,100 --> 00:13:15,940
So that's how you each have information, additional information from this page.

110
00:13:16,990 --> 00:13:22,840
So I'm using this one and then I'm constructing the query.

111
00:13:22,840 --> 00:13:26,480
Select which side of the table.

112
00:13:26,500 --> 00:13:33,970
Now, from this information schema tables and then I'm opening it to the tables column tables.

113
00:13:35,380 --> 00:13:38,160
So here I am opening the tables.

114
00:13:38,530 --> 00:13:46,110
And if the table I'm there will be, uh, this, uh, table headers.

115
00:13:46,570 --> 00:13:49,690
So this may be able to do in both of these.

116
00:13:50,740 --> 00:13:51,570
You can see here.

117
00:13:52,960 --> 00:13:57,010
And if you go back here, you can see I can give this to happen.

118
00:13:57,220 --> 00:14:03,610
So whenever you extend this using the beautiful soup, you will get some few of these in the same page.

119
00:14:03,640 --> 00:14:05,590
So that's where I'm going to clear them.

120
00:14:05,920 --> 00:14:11,390
So finally, I get the tables are the tables negativeness, so in the tables.

121
00:14:11,440 --> 00:14:16,450
So for each table I'm going to draw from this and coding for this.

122
00:14:16,490 --> 00:14:20,190
Uh, you are so union select from the following schema.

123
00:14:20,290 --> 00:14:24,130
The columns we're telling them is close to the looping of the.

124
00:14:26,860 --> 00:14:33,760
And then I am putting in the desert intertemporal and using the discover of the desert, so in the desert

125
00:14:33,760 --> 00:14:35,520
I'm expecting these columns.

126
00:14:36,610 --> 00:14:41,300
So so these columns are the dictionary.

127
00:14:41,350 --> 00:14:47,070
So the key contains the table name and the value contents that are the columns, you know.

128
00:14:48,940 --> 00:14:54,670
So in those columns, I'm retreating or the keys, that means that they were names and I'm extracting

129
00:14:54,670 --> 00:14:56,310
the data.

130
00:14:56,590 --> 00:15:00,940
So from that, I mean, the keys, that means every key every day.

131
00:15:01,630 --> 00:15:09,820
So I'm getting it and I have to bring it to the normal fire.

132
00:15:10,030 --> 00:15:14,990
Then I also asked the help from this car to visualize these tables.

133
00:15:15,430 --> 00:15:19,760
Then one of the friends said that this rich model.

134
00:15:19,780 --> 00:15:21,200
So here we have the table.

135
00:15:21,400 --> 00:15:26,890
So you need to construct any so you can just add the Rosengard secret under the table format.

136
00:15:27,820 --> 00:15:31,030
So to test this, let's go and copy the order.

137
00:15:40,280 --> 00:15:41,580
So let's go with this one.

138
00:15:43,220 --> 00:15:46,670
So here you need to push this you are.

139
00:15:49,020 --> 00:15:54,840
So first, we're using our nation function to determine number of columns, and in those columns, you

140
00:15:54,840 --> 00:15:56,870
are determining which column, certain columns.

141
00:15:57,480 --> 00:16:00,890
So and then I'm going to dump that right there.

142
00:16:02,130 --> 00:16:07,740
So let's, uh, I'm modifying this a little bit to the six tables.

143
00:16:08,130 --> 00:16:10,660
The first six tables will get the information.

144
00:16:11,010 --> 00:16:16,980
So if I want to show you the hard information, it will take so much of, uh, time to run this model.

145
00:16:17,280 --> 00:16:18,120
So run this.

146
00:16:31,950 --> 00:16:36,120
So this is a query we are sending and we are getting this response.

147
00:16:37,850 --> 00:16:40,200
So are these people starting to.

148
00:16:40,310 --> 00:16:45,420
So let's increase the number to 62 or a certain.

149
00:16:45,620 --> 00:16:48,230
So instead of this pen, you can sell them to afterwards.

150
00:17:10,540 --> 00:17:17,530
So you can see this dictionary is the six tables with the columns.

151
00:17:20,170 --> 00:17:22,480
So these do not have any information.

152
00:17:23,260 --> 00:17:24,720
OK, let's go and see.

153
00:17:36,670 --> 00:17:38,680
Well, let's try to then pardon for Mr..

154
00:18:15,320 --> 00:18:23,090
OK, yes, I am stopping here, it is taking so much time, so I will show you the recent dump, so

155
00:18:23,090 --> 00:18:24,070
I have it on that comment.

156
00:18:24,080 --> 00:18:25,690
I, however, need to fight it now.

157
00:18:26,180 --> 00:18:30,110
So this is what it looked like after the current executes.

158
00:18:30,920 --> 00:18:32,630
So you get the art in there.

159
00:18:32,900 --> 00:18:34,970
Nice table format.

