1
00:00:00,300 --> 00:00:06,050
So in the previous have seen their business connections on this, will be seeing the union rescuing

2
00:00:06,100 --> 00:00:06,530
actions.

3
00:00:07,110 --> 00:00:11,390
So first let me get the contents of this in 48.

4
00:00:16,330 --> 00:00:23,200
So, uh, we came to know that there will be a school committee in the back like this, so start using

5
00:00:23,200 --> 00:00:26,150
them so we don't know the number of columns.

6
00:00:26,170 --> 00:00:27,190
It is true.

7
00:00:27,190 --> 00:00:28,900
We, uh, in the Bakken.

8
00:00:28,980 --> 00:00:37,900
So to determine the number of forums, uh, first what we can do is we can use the order statement,

9
00:00:39,230 --> 00:00:40,590
uh, underbite.

10
00:00:40,990 --> 00:00:45,250
So one so one represents the first column.

11
00:00:45,280 --> 00:00:53,650
Here we are getting so Stallman's our columns are three columns and getting all this info and sorting

12
00:00:53,650 --> 00:00:55,100
according to the first column.

13
00:00:55,120 --> 00:00:57,280
So first column contains integer rate.

14
00:00:57,550 --> 00:01:00,530
So one is the first to second filter.

15
00:01:00,550 --> 00:01:04,640
So it is not ready in sorting order, but it gives you in a sorting order.

16
00:01:05,110 --> 00:01:13,240
So there is no change because the idea has already been sort of if I change from one to two, uh, the

17
00:01:13,240 --> 00:01:18,690
sorting takes place according with the user name column, which is a string.

18
00:01:30,490 --> 00:01:37,320
Which is a string and you can see Arrow Flash, Superman, your face, so they're already in a sorting

19
00:01:37,330 --> 00:01:41,560
out now if you want if they want to descending order, I can say this.

20
00:01:42,220 --> 00:01:46,840
And now you can see the difference between this result and this result.

21
00:01:47,200 --> 00:01:49,290
That is Superman and the Flash and Arrow.

22
00:01:49,900 --> 00:01:57,360
So you can start using this order first, according to three.

23
00:01:58,060 --> 00:02:04,930
Now you can see the flashes the first because it comes first and B and then as so here, we can use

24
00:02:04,930 --> 00:02:10,390
this number just to sort according to this number of.

25
00:02:11,500 --> 00:02:13,390
So, no, I'm going to give you four.

26
00:02:14,140 --> 00:02:15,520
So it will do that.

27
00:02:16,420 --> 00:02:23,610
So unknown column four in all of us, that means there are only three columns, there is no food column.

28
00:02:23,800 --> 00:02:29,650
So you are trying to get the food current, which is not present for traffic to go and get the same

29
00:02:29,680 --> 00:02:36,530
order for the same reasons that are not columns if I get three and I get the result.

30
00:02:37,000 --> 00:02:42,080
So that means there are three columns in this table, OK?

31
00:02:42,130 --> 00:02:42,610
That's right.

32
00:02:43,150 --> 00:02:48,160
Now, uh, let's go and do this.

33
00:02:48,790 --> 00:02:54,310
OK, we are also using, uh, this union segment, so let me explain that one.

34
00:02:56,350 --> 00:03:02,670
So Union is used to combine both those of Busalacchi shipments.

35
00:03:03,100 --> 00:03:04,870
So this is one salad.

36
00:03:05,140 --> 00:03:13,270
And here I can say union and I can say another salad strictly from for.

37
00:03:17,170 --> 00:03:23,310
OK, so here I got it, here you can see where I got it.

38
00:03:23,880 --> 00:03:28,010
So here there are three columns and here there is only one column.

39
00:03:29,010 --> 00:03:31,200
So that means I got the error.

40
00:03:31,530 --> 00:03:36,450
So what I can do is I can it not come?

41
00:03:37,350 --> 00:03:43,390
I'm trying to get up with the two columns and so I get the same idea.

42
00:03:44,160 --> 00:03:53,250
Now, what I did was I can sit and I'm just getting some random data and matching the number of columns

43
00:03:53,760 --> 00:03:56,100
this statement is getting entered into.

44
00:03:56,220 --> 00:03:58,760
Now you can see we got the na na na.

45
00:03:59,910 --> 00:04:03,810
We got the, uh, dessert.

46
00:04:04,260 --> 00:04:05,990
Then there are three numbers.

47
00:04:06,150 --> 00:04:12,720
That means this first to statement contains or is retrieving the three columns.

48
00:04:13,080 --> 00:04:19,320
So you can see we have the pool that one needs sorting and another one is by union.

49
00:04:19,440 --> 00:04:24,510
OK, so now we can use these two methods to determine number of columns.

50
00:04:24,940 --> 00:04:26,790
Uh, they're quite easy.

51
00:04:26,820 --> 00:04:27,100
Three.

52
00:04:27,570 --> 00:04:29,470
So now let's go in and do the.

53
00:04:49,620 --> 00:04:56,640
OK, let's start the gifts and then after one.

54
00:05:03,020 --> 00:05:09,620
So I'm trying to sort that according to the current one, and so we get the result.

55
00:05:09,650 --> 00:05:10,860
OK, that's fine.

56
00:05:10,880 --> 00:05:23,950
So now let's turn this to you and you can see the arrangement of these has been changed because of this

57
00:05:23,950 --> 00:05:30,020
second, uh, changing of this order, sorting out its three.

58
00:05:30,650 --> 00:05:32,030
So here I get the three.

59
00:05:32,120 --> 00:05:38,010
So it's being worked on the floor and I got there.

60
00:05:38,270 --> 00:05:39,710
So what are you doing it there?

61
00:05:39,710 --> 00:05:44,460
Because there are there is no fourth column and we are trying to sort according to the fifth column.

62
00:05:44,990 --> 00:05:47,000
So because there is no one there.

63
00:05:47,030 --> 00:05:50,060
So that means there are the three columns.

64
00:06:04,440 --> 00:06:10,760
So there are three columns now what we can do is you can use the server model.

65
00:06:13,970 --> 00:06:20,520
How we got there, because we are starting only one column against the number of columns, we don't

66
00:06:20,520 --> 00:06:25,100
know, let's increase our column count.

67
00:06:26,730 --> 00:06:27,640
So, OK.

68
00:06:27,900 --> 00:06:30,950
So let's say a little.

69
00:06:33,840 --> 00:06:43,680
And now you can see we got that means we got that we have to equally to the trainers and there are three

70
00:06:43,680 --> 00:06:47,340
columns so you can see congratulations, you are the love.

71
00:06:57,110 --> 00:06:59,540
So come on, come on now.

72
00:06:59,960 --> 00:07:04,180
And then the comment so successfully solved this.

73
00:07:06,510 --> 00:07:12,560
OK, the next step is going to be determining which column has that string.

74
00:07:13,070 --> 00:07:14,420
OK, that's Gernon.

75
00:07:14,840 --> 00:07:24,160
Since we came to know that there are three columns that say so here in my experiences in political configuration.

76
00:07:24,380 --> 00:07:29,430
So I decided to use Mahmuddin Integer and it's also happening.

77
00:07:29,450 --> 00:07:30,050
That's true.

78
00:07:30,440 --> 00:07:38,480
So in a normal, if you will position, this will raise an error because this is the string and it will

79
00:07:38,510 --> 00:07:40,940
not be shown along with the integer.

80
00:07:43,500 --> 00:07:53,570
So here, if you get this, that means this first column is a strong column, so we can just say no

81
00:07:55,320 --> 00:07:57,690
and then we are changing this to second column.

82
00:07:58,920 --> 00:08:04,080
So here we can see and see what this result in this operation that means.

83
00:08:04,410 --> 00:08:06,940
The second column is of the spring.

84
00:08:09,600 --> 00:08:12,900
And if you are getting the similar way, what you can do is.

85
00:08:17,180 --> 00:08:27,770
So you can take that note to string and check whether you got the Basilicata, not if you back the third

86
00:08:27,770 --> 00:08:34,620
column is this tape and we can get some much more juicy information about this column.

87
00:08:36,740 --> 00:08:39,650
So this is described as being computer.

88
00:08:44,070 --> 00:08:47,000
So let's go and see the next.

89
00:08:56,740 --> 00:08:58,120
So sex is the.

90
00:09:43,230 --> 00:09:45,540
So let's click on their category bets.

91
00:09:45,720 --> 00:09:51,830
So this is prone to infection rates again, arguably one.

92
00:09:54,810 --> 00:10:01,180
So that is the first column and let's change it to the second column.

93
00:10:01,200 --> 00:10:02,640
So there is two columns.

94
00:10:03,060 --> 00:10:06,040
So there are two columns and two, three.

95
00:10:07,980 --> 00:10:12,960
So there are three columns has changed two, four.

96
00:10:13,590 --> 00:10:16,080
And that means there are three columns.

97
00:10:17,040 --> 00:10:19,260
So let's first copy this and push to.

98
00:10:22,100 --> 00:10:30,670
So there are three columns, Sarah Palin, Molyneaux, Common.

99
00:10:32,540 --> 00:10:34,410
So we got the arrow.

100
00:10:35,240 --> 00:10:37,480
I did not put the onion my.

101
00:10:39,830 --> 00:10:41,600
So there are three columns.

102
00:10:41,780 --> 00:10:44,180
So determine which column is the string.

103
00:10:48,570 --> 00:10:50,820
That's, uh, w.

104
00:10:53,470 --> 00:10:54,120
So

105
00:10:57,450 --> 00:10:59,750
let's change to the second column.

106
00:11:03,380 --> 00:11:05,610
And yet you can see in the courtroom how yet.

107
00:11:05,900 --> 00:11:11,810
So that means we are successfully determined that column is different.

108
00:11:12,380 --> 00:11:15,390
So this is the fourth biggest, you know, and the year.

109
00:11:15,830 --> 00:11:17,380
So here's what they're asking make.

110
00:11:17,420 --> 00:11:27,560
The database includes this one that copy this instead of you page this and we're going to show you need

111
00:11:27,560 --> 00:11:35,030
to display it in this column so you can see now you have all this lot so you can also determine the

112
00:11:35,030 --> 00:11:35,780
third column.

113
00:11:42,620 --> 00:11:45,240
So only second column users trying to.

114
00:11:49,580 --> 00:11:57,230
So we will determine the number of farms and which comes of tonight soccer.

115
00:11:57,870 --> 00:12:05,110
So after finding which commission, if there is another database, you can order on the table that the

116
00:12:05,130 --> 00:12:05,980
fools like this.

117
00:12:06,380 --> 00:12:07,460
So let's solve this.

118
00:12:27,910 --> 00:12:39,540
Galchen fits the category parameter is prone to ask, well, that's the domain, Scoppetta is best based

119
00:12:39,620 --> 00:12:39,900
here.

120
00:12:45,470 --> 00:12:57,540
Now, let's determine number of columns starting according to first column, so it works a second column.

121
00:12:58,760 --> 00:13:00,610
So there are two columns,

122
00:13:03,800 --> 00:13:07,310
so there are only two columns to.

123
00:13:15,140 --> 00:13:16,650
So there are two problems.

124
00:13:16,760 --> 00:13:22,640
So let's go to the scene of ostinato as a stranger.

125
00:13:24,530 --> 00:13:30,790
So now you can see the view here because we are in the second statement.

126
00:13:30,800 --> 00:13:37,800
So that means the fast food is fast, is extremely.

127
00:13:42,410 --> 00:13:44,060
Let's try for a second call.

128
00:13:48,140 --> 00:13:50,640
So, yeah, so you can see the year here.

129
00:13:51,050 --> 00:13:59,570
So what I can say is they're telling us there is a user stable and in that we need to use a password.

130
00:14:08,420 --> 00:14:12,380
So username and password from users.

131
00:14:15,620 --> 00:14:19,760
So you can see what dark matter, the password, password.

132
00:14:20,420 --> 00:14:21,250
So there are three.

133
00:14:21,290 --> 00:14:23,020
This one isn't a setup.

134
00:14:23,960 --> 00:14:28,140
So this is if you know that there are there is an alert.

135
00:14:29,180 --> 00:14:37,910
See, in the next two years how to view the tables of by the information that came up, I suppose there

136
00:14:37,910 --> 00:14:45,470
will be a case where there is only one column existing and second one is not the standard.

137
00:14:47,780 --> 00:14:52,670
So in that case, what you can do is you can query multiple times for the one thing for the user name

138
00:14:52,730 --> 00:15:06,200
and second content for the passport, or automatically you can use the concat function concat of user

139
00:15:06,350 --> 00:15:07,320
name, comma.

140
00:15:07,760 --> 00:15:17,000
So we need to specify it's summer string between those particular passport and who don't.

141
00:15:18,430 --> 00:15:26,360
I know you can see we got the Kearns's Truecaller passport, username and password so you can use the

142
00:15:26,360 --> 00:15:27,380
concat function.

143
00:15:30,400 --> 00:15:36,630
So the next level is, uh, about the same, but they have shown us in a different light.

144
00:15:36,640 --> 00:15:44,100
So what you can do is you can use this all happened so you can just up and meet.

145
00:15:46,460 --> 00:15:50,510
Let's try that one also username.

146
00:15:53,410 --> 00:15:56,780
Kolon Passo and her daughter.

147
00:15:57,730 --> 00:16:01,930
So we got the same result, so you can also join the squadron to.

148
00:16:05,170 --> 00:16:06,190
It's this rush.

149
00:16:09,390 --> 00:16:12,510
So you can see the username searchable, so.

150
00:16:15,370 --> 00:16:24,040
So that's my this so these are the techniques you can you can first determine how many condoms and which

151
00:16:24,040 --> 00:16:27,520
condoms are screened and then getting the information from them.

152
00:16:28,030 --> 00:16:33,700
So now let's go in and try to automate with the python.

153
00:16:44,770 --> 00:16:51,490
So what we have is are done by so underbody and it's.

154
00:17:04,090 --> 00:17:11,260
It's turning number of columns with underbite.

155
00:17:20,720 --> 00:17:31,790
So let's determine in range of one to 50, so of course, less than 50 columns in the most of the cases.

156
00:17:31,820 --> 00:17:34,760
You can also increase to 100 or 150, whatever you want.

157
00:17:35,600 --> 00:17:40,490
So from one to 50, what you can do is.

158
00:17:43,860 --> 00:17:48,960
Equal is equal to other parents of children.

159
00:17:50,760 --> 00:17:54,330
So what you going to build is arguably one.

160
00:18:00,450 --> 00:18:03,360
Arguably by one and the.

161
00:18:03,930 --> 00:18:11,270
So here in the place of one, you're going to need to use three, four, etc. So we have already underway

162
00:18:11,310 --> 00:18:19,680
and plus I asked you out of I and then comment.

163
00:18:19,890 --> 00:18:26,610
So this will be the autobody one all the way to October three, etc., up to 50.

164
00:18:27,090 --> 00:18:32,310
And then of course because there you are plus Kuwait.

165
00:18:33,960 --> 00:18:35,910
So you are to the dishwater.

166
00:18:45,970 --> 00:18:54,300
So this year will pass around the dysfunctional nature and order in the art when you are using the order

167
00:18:54,340 --> 00:19:05,920
key word, you look at the characters like 200 or the status quo is costing the coastal 200, then print

168
00:19:06,280 --> 00:19:07,540
that column.

169
00:19:10,450 --> 00:19:12,370
Is president.

170
00:19:14,960 --> 00:19:16,490
Not for my golf, I.

171
00:19:22,610 --> 00:19:35,590
Else there is no quorum and we get the error, what we can do is bring the total number.

172
00:19:38,200 --> 00:19:44,080
Number of columns are this one for Mackoff.

173
00:19:47,560 --> 00:19:50,170
A sweeping Carrero plus one.

174
00:19:52,890 --> 00:19:56,520
OK, it's I so what you can do is return.

175
00:19:59,520 --> 00:20:09,240
I so I will be the number of columns, so Audrey Nixon, articulateness columns, columns.

176
00:20:12,900 --> 00:20:18,250
So that's going to run this quarter on this prison abuse prison.

177
00:20:18,280 --> 00:20:18,990
So.

178
00:20:22,430 --> 00:20:24,150
OK, yeah, so OK.

179
00:20:24,710 --> 00:20:28,790
And the third column, it gave me a row so I can need to squeeze five minus one.

180
00:20:31,270 --> 00:20:35,580
So there are two columns, that's what.

181
00:20:42,560 --> 00:20:51,890
So let me let us try the same with this, uh, not OK using the union threatener.

182
00:21:04,930 --> 00:21:14,070
So this will be our third select number and two, how many times the number of times you are going to

183
00:21:14,140 --> 00:21:27,520
treat and the comment so far, I just want to be saying 50 columns like this one and then I'd say quality

184
00:21:28,120 --> 00:21:28,780
equals to.

185
00:21:31,250 --> 00:21:41,960
Now, come on, we need to make the private eye so on the second iteration to Wilkommen Okarma.

186
00:21:44,860 --> 00:21:51,940
So Pottermore, the last comma, you can say zero is two minus two.

187
00:21:55,090 --> 00:21:57,760
Minus one, because the last one is exquisite.

188
00:21:58,540 --> 00:22:07,840
So if the IEM you get the dollars and there will be no comma there, so this will be very useful for

189
00:22:08,200 --> 00:22:08,410
building.

190
00:22:10,980 --> 00:22:13,250
Two of you are plus.

191
00:22:14,950 --> 00:22:22,570
So after this year, you need to specify a single code and union so that there is already space and

192
00:22:22,570 --> 00:22:23,920
then need to with the code.

193
00:22:27,310 --> 00:22:34,180
And then at the last minute, so you for not start a school.

194
00:22:42,460 --> 00:22:45,590
Five hundred, 500, that is somewhere around.

195
00:22:46,520 --> 00:22:50,000
We are going to just call them.

196
00:22:54,410 --> 00:22:59,330
Gil, 500 Internal Revenue.

197
00:23:03,250 --> 00:23:05,560
The format of I.

198
00:23:07,670 --> 00:23:12,880
And is that live or not, that Oscar?

199
00:23:13,910 --> 00:23:23,570
Give me 200 permits, this number of hours have been equal to the first district statement before the

200
00:23:23,570 --> 00:23:24,640
union word.

201
00:23:25,730 --> 00:23:26,600
So print.

202
00:23:30,030 --> 00:23:31,420
But the number of.

203
00:23:35,410 --> 00:23:39,740
Columns are not far off.

204
00:23:40,990 --> 00:23:50,350
I saw her done I so this will be I think this will be good.

205
00:23:50,560 --> 00:23:55,870
So let me turn this to so let me run this.

206
00:23:56,890 --> 00:23:58,290
You should get the two columns.

207
00:23:59,260 --> 00:24:00,640
So we got the two columns.

208
00:24:13,440 --> 00:24:17,160
OK, so we have a tremendous number of columns here.

209
00:24:17,490 --> 00:24:21,320
Now, what we need to do is reach those to OK.

210
00:24:25,730 --> 00:24:27,400
So we need to use this one, right?

211
00:24:27,440 --> 00:24:27,700
Uh.

212
00:24:30,890 --> 00:24:36,700
So we have already found a pool here that these number of columns have been present.

213
00:24:49,160 --> 00:24:50,200
Sonorities.

214
00:24:53,640 --> 00:25:01,170
Quite a moth, you are common cause so this chorus will be returned from this art rejection of any number

215
00:25:01,170 --> 00:25:01,890
of columns.

216
00:25:23,330 --> 00:25:25,730
So the payload will be like this.

217
00:25:28,930 --> 00:25:39,580
Unions are the string and another, etc. So this year will be changing from this position to second

218
00:25:40,030 --> 00:25:41,240
and third person and so on.

219
00:25:41,920 --> 00:25:44,710
So I have already found this current staggering from.

220
00:25:44,980 --> 00:25:49,710
So that will replace the and the substring from the spring.

221
00:25:50,320 --> 00:25:53,690
So you can copy this one and paste here.

222
00:25:55,690 --> 00:26:02,980
So here is the total scheme and source the thing you want to change and that from the screen to the

223
00:26:02,980 --> 00:26:04,800
screen and which occurrence.

224
00:26:05,470 --> 00:26:09,940
So for example, there is the stream ABC.

225
00:26:13,480 --> 00:26:20,800
You see, so if you want to take the first occurrence of ABC, you can space for the string and source

226
00:26:20,800 --> 00:26:28,750
as ABC and you want to change it to some right injection and into space space for that one.

227
00:26:28,960 --> 00:26:32,590
And you need to switch flight, which substring whether this one.

228
00:26:33,100 --> 00:26:34,590
This one, which occurrence?

229
00:26:34,600 --> 00:26:36,520
The first or second occurrence.

230
00:26:36,850 --> 00:26:40,660
So that will be, uh, functionality of this function.

231
00:26:41,950 --> 00:26:43,510
So this will be very helpful.

232
00:26:50,470 --> 00:26:59,670
So far, I mean, grenvilles, and because we already came to know that there are and columns, so let's

233
00:26:59,860 --> 00:27:06,820
and presume so from one to and there are 10 columns from one to 10 column.

234
00:27:10,650 --> 00:27:12,060
Quarry's equals to.

235
00:27:16,190 --> 00:27:20,810
Now, Linda, I the same gender, the nulls and.

236
00:27:23,750 --> 00:27:27,030
Quality of zero is two minus one.

237
00:27:27,410 --> 00:27:32,670
So we are truncating the life to the last to come up.

238
00:27:34,370 --> 00:27:42,680
So in this not what we do is replacement of quality.

239
00:27:43,280 --> 00:27:52,970
So in the career, I want to replace tunel everything, each with a single copy and each occurrence

240
00:27:52,970 --> 00:27:53,130
of.

241
00:27:53,870 --> 00:28:01,910
So whenever I am moving from one to 10, the first occurrence of this copy and the second occurrence

242
00:28:01,910 --> 00:28:04,220
will be replaced by a quarter in the second iteration.

243
00:28:04,850 --> 00:28:08,440
So in that case, you get the string.

244
00:28:11,180 --> 00:28:13,380
So here we are riding the string.

245
00:28:13,440 --> 00:28:14,310
OK, so let's

246
00:28:17,000 --> 00:28:18,230
for you water.

247
00:28:21,600 --> 00:28:28,020
OK, now we need to get the records, not get of what you can see, you are helpless.

248
00:28:33,730 --> 00:28:35,470
So disgraceful union.

249
00:28:39,330 --> 00:28:47,910
Solo press, free press and all the comments.

250
00:28:54,190 --> 00:28:59,740
So it's not status quo, 200.

251
00:29:04,300 --> 00:29:05,440
So then.

252
00:29:08,650 --> 00:29:11,740
Column B, string type.

253
00:29:14,430 --> 00:29:15,390
Former like.

254
00:29:24,700 --> 00:29:32,710
So I think this one solid said it should work, so it's going to run this so fast, train number of

255
00:29:32,710 --> 00:29:37,950
columns on there are two columns, so current Bush Clinton.

256
00:29:44,490 --> 00:29:50,590
But the calm one has a day and also we got the current two as it stands, right.

257
00:29:50,970 --> 00:29:53,360
So both currents are vulnerable for this one.

258
00:29:56,570 --> 00:29:59,000
So we should also get the carnivalesque on tape.

259
00:30:05,150 --> 00:30:07,180
So do not we get that one?

260
00:30:21,310 --> 00:30:22,010
I'm sorry.

261
00:30:22,030 --> 00:30:23,450
We need to multiply.

262
00:30:23,800 --> 00:30:27,260
And so this no offense, I'm so sorry.

263
00:30:27,850 --> 00:30:32,380
So there will be already this number of months.

264
00:30:32,980 --> 00:30:38,980
That means the number of columns, not on this column to present.

265
00:31:46,120 --> 00:31:52,120
OK, it's trying for three columns by train for three columns.

266
00:31:56,530 --> 00:32:05,290
So barring some returning of disorder and action tonight, minus one, so how to fix the.

267
00:32:09,100 --> 00:32:14,440
So there are two columns, so now you can see of and current.

268
00:32:15,310 --> 00:32:20,280
So we have successfully automated this whole process.

269
00:32:20,590 --> 00:32:28,030
So whenever you want to find whether particular parameter is available to union or whatever, you can

270
00:32:28,030 --> 00:32:31,170
just cover this and this group to distribute free.

271
00:32:32,200 --> 00:32:33,950
So that's our goal for this video.

272
00:32:34,600 --> 00:32:36,770
You can also automate this using them.

273
00:32:37,390 --> 00:32:44,650
I did not, but this was in this case, we know that there is there were no user users, if you don't

274
00:32:44,650 --> 00:32:44,930
know.

275
00:32:44,960 --> 00:32:50,410
So we need to do that user order tables via this information schema.

276
00:32:50,830 --> 00:32:52,660
So we'll be doing in the next few years.

