So in the previous have seen their business connections on this, will be seeing the union rescuing
actions.
So first let me get the contents of this in 48.
So, uh, we came to know that there will be a school committee in the back like this, so start using
them so we don't know the number of columns.
It is true.
We, uh, in the Bakken.
So to determine the number of forums, uh, first what we can do is we can use the order statement,
uh, underbite.
So one so one represents the first column.
Here we are getting so Stallman's our columns are three columns and getting all this info and sorting
according to the first column.
So first column contains integer rate.
So one is the first to second filter.
So it is not ready in sorting order, but it gives you in a sorting order.
So there is no change because the idea has already been sort of if I change from one to two, uh, the
sorting takes place according with the user name column, which is a string.
Which is a string and you can see Arrow Flash, Superman, your face, so they're already in a sorting
out now if you want if they want to descending order, I can say this.
And now you can see the difference between this result and this result.
That is Superman and the Flash and Arrow.
So you can start using this order first, according to three.
Now you can see the flashes the first because it comes first and B and then as so here, we can use
this number just to sort according to this number of.
So, no, I'm going to give you four.
So it will do that.
So unknown column four in all of us, that means there are only three columns, there is no food column.
So you are trying to get the food current, which is not present for traffic to go and get the same
order for the same reasons that are not columns if I get three and I get the result.
So that means there are three columns in this table, OK?
That's right.
Now, uh, let's go and do this.
OK, we are also using, uh, this union segment, so let me explain that one.
So Union is used to combine both those of Busalacchi shipments.
So this is one salad.
And here I can say union and I can say another salad strictly from for.
OK, so here I got it, here you can see where I got it.
So here there are three columns and here there is only one column.
So that means I got the error.
So what I can do is I can it not come?
I'm trying to get up with the two columns and so I get the same idea.
Now, what I did was I can sit and I'm just getting some random data and matching the number of columns
this statement is getting entered into.
Now you can see we got the na na na.
We got the, uh, dessert.
Then there are three numbers.
That means this first to statement contains or is retrieving the three columns.
So you can see we have the pool that one needs sorting and another one is by union.
OK, so now we can use these two methods to determine number of columns.
Uh, they're quite easy.
Three.
So now let's go in and do the.
OK, let's start the gifts and then after one.
So I'm trying to sort that according to the current one, and so we get the result.
OK, that's fine.
So now let's turn this to you and you can see the arrangement of these has been changed because of this
second, uh, changing of this order, sorting out its three.
So here I get the three.
So it's being worked on the floor and I got there.
So what are you doing it there?
Because there are there is no fourth column and we are trying to sort according to the fifth column.
So because there is no one there.
So that means there are the three columns.
So there are three columns now what we can do is you can use the server model.
How we got there, because we are starting only one column against the number of columns, we don't
know, let's increase our column count.
So, OK.
So let's say a little.
And now you can see we got that means we got that we have to equally to the trainers and there are three
columns so you can see congratulations, you are the love.
So come on, come on now.
And then the comment so successfully solved this.
OK, the next step is going to be determining which column has that string.
OK, that's Gernon.
Since we came to know that there are three columns that say so here in my experiences in political configuration.
So I decided to use Mahmuddin Integer and it's also happening.
That's true.
So in a normal, if you will position, this will raise an error because this is the string and it will
not be shown along with the integer.
So here, if you get this, that means this first column is a strong column, so we can just say no
and then we are changing this to second column.
So here we can see and see what this result in this operation that means.
The second column is of the spring.
And if you are getting the similar way, what you can do is.
So you can take that note to string and check whether you got the Basilicata, not if you back the third
column is this tape and we can get some much more juicy information about this column.
So this is described as being computer.
So let's go and see the next.
So sex is the.
So let's click on their category bets.
So this is prone to infection rates again, arguably one.
So that is the first column and let's change it to the second column.
So there is two columns.
So there are two columns and two, three.
So there are three columns has changed two, four.
And that means there are three columns.
So let's first copy this and push to.
So there are three columns, Sarah Palin, Molyneaux, Common.
So we got the arrow.
I did not put the onion my.
So there are three columns.
So determine which column is the string.
That's, uh, w.
So
let's change to the second column.
And yet you can see in the courtroom how yet.
So that means we are successfully determined that column is different.
So this is the fourth biggest, you know, and the year.
So here's what they're asking make.
The database includes this one that copy this instead of you page this and we're going to show you need
to display it in this column so you can see now you have all this lot so you can also determine the
third column.
So only second column users trying to.
So we will determine the number of farms and which comes of tonight soccer.
So after finding which commission, if there is another database, you can order on the table that the
fools like this.
So let's solve this.
Galchen fits the category parameter is prone to ask, well, that's the domain, Scoppetta is best based
here.
Now, let's determine number of columns starting according to first column, so it works a second column.
So there are two columns,
so there are only two columns to.
So there are two problems.
So let's go to the scene of ostinato as a stranger.
So now you can see the view here because we are in the second statement.
So that means the fast food is fast, is extremely.
Let's try for a second call.
So, yeah, so you can see the year here.
So what I can say is they're telling us there is a user stable and in that we need to use a password.
So username and password from users.
So you can see what dark matter, the password, password.
So there are three.
This one isn't a setup.
So this is if you know that there are there is an alert.
See, in the next two years how to view the tables of by the information that came up, I suppose there
will be a case where there is only one column existing and second one is not the standard.
So in that case, what you can do is you can query multiple times for the one thing for the user name
and second content for the passport, or automatically you can use the concat function concat of user
name, comma.
So we need to specify it's summer string between those particular passport and who don't.
I know you can see we got the Kearns's Truecaller passport, username and password so you can use the
concat function.
So the next level is, uh, about the same, but they have shown us in a different light.
So what you can do is you can use this all happened so you can just up and meet.
Let's try that one also username.
Kolon Passo and her daughter.
So we got the same result, so you can also join the squadron to.
It's this rush.
So you can see the username searchable, so.
So that's my this so these are the techniques you can you can first determine how many condoms and which
condoms are screened and then getting the information from them.
So now let's go in and try to automate with the python.
So what we have is are done by so underbody and it's.
It's turning number of columns with underbite.
So let's determine in range of one to 50, so of course, less than 50 columns in the most of the cases.
You can also increase to 100 or 150, whatever you want.
So from one to 50, what you can do is.
Equal is equal to other parents of children.
So what you going to build is arguably one.
Arguably by one and the.
So here in the place of one, you're going to need to use three, four, etc. So we have already underway
and plus I asked you out of I and then comment.
So this will be the autobody one all the way to October three, etc., up to 50.
And then of course because there you are plus Kuwait.
So you are to the dishwater.
So this year will pass around the dysfunctional nature and order in the art when you are using the order
key word, you look at the characters like 200 or the status quo is costing the coastal 200, then print
that column.
Is president.
Not for my golf, I.
Else there is no quorum and we get the error, what we can do is bring the total number.
Number of columns are this one for Mackoff.
A sweeping Carrero plus one.
OK, it's I so what you can do is return.
I so I will be the number of columns, so Audrey Nixon, articulateness columns, columns.
So that's going to run this quarter on this prison abuse prison.
So.
OK, yeah, so OK.
And the third column, it gave me a row so I can need to squeeze five minus one.
So there are two columns, that's what.
So let me let us try the same with this, uh, not OK using the union threatener.
So this will be our third select number and two, how many times the number of times you are going to
treat and the comment so far, I just want to be saying 50 columns like this one and then I'd say quality
equals to.
Now, come on, we need to make the private eye so on the second iteration to Wilkommen Okarma.
So Pottermore, the last comma, you can say zero is two minus two.
Minus one, because the last one is exquisite.
So if the IEM you get the dollars and there will be no comma there, so this will be very useful for
building.
Two of you are plus.
So after this year, you need to specify a single code and union so that there is already space and
then need to with the code.
And then at the last minute, so you for not start a school.
Five hundred, 500, that is somewhere around.
We are going to just call them.
Gil, 500 Internal Revenue.
The format of I.
And is that live or not, that Oscar?
Give me 200 permits, this number of hours have been equal to the first district statement before the
union word.
So print.
But the number of.
Columns are not far off.
I saw her done I so this will be I think this will be good.
So let me turn this to so let me run this.
You should get the two columns.
So we got the two columns.
OK, so we have a tremendous number of columns here.
Now, what we need to do is reach those to OK.
So we need to use this one, right?
Uh.
So we have already found a pool here that these number of columns have been present.
Sonorities.
Quite a moth, you are common cause so this chorus will be returned from this art rejection of any number
of columns.
So the payload will be like this.
Unions are the string and another, etc. So this year will be changing from this position to second
and third person and so on.
So I have already found this current staggering from.
So that will replace the and the substring from the spring.
So you can copy this one and paste here.
So here is the total scheme and source the thing you want to change and that from the screen to the
screen and which occurrence.
So for example, there is the stream ABC.
You see, so if you want to take the first occurrence of ABC, you can space for the string and source
as ABC and you want to change it to some right injection and into space space for that one.
And you need to switch flight, which substring whether this one.
This one, which occurrence?
The first or second occurrence.
So that will be, uh, functionality of this function.
So this will be very helpful.
So far, I mean, grenvilles, and because we already came to know that there are and columns, so let's
and presume so from one to and there are 10 columns from one to 10 column.
Quarry's equals to.
Now, Linda, I the same gender, the nulls and.
Quality of zero is two minus one.
So we are truncating the life to the last to come up.
So in this not what we do is replacement of quality.
So in the career, I want to replace tunel everything, each with a single copy and each occurrence
of.
So whenever I am moving from one to 10, the first occurrence of this copy and the second occurrence
will be replaced by a quarter in the second iteration.
So in that case, you get the string.
So here we are riding the string.
OK, so let's
for you water.
OK, now we need to get the records, not get of what you can see, you are helpless.
So disgraceful union.
Solo press, free press and all the comments.
So it's not status quo, 200.
So then.
Column B, string type.
Former like.
So I think this one solid said it should work, so it's going to run this so fast, train number of
columns on there are two columns, so current Bush Clinton.
But the calm one has a day and also we got the current two as it stands, right.
So both currents are vulnerable for this one.
So we should also get the carnivalesque on tape.
So do not we get that one?
I'm sorry.
We need to multiply.
And so this no offense, I'm so sorry.
So there will be already this number of months.
That means the number of columns, not on this column to present.
OK, it's trying for three columns by train for three columns.
So barring some returning of disorder and action tonight, minus one, so how to fix the.
So there are two columns, so now you can see of and current.
So we have successfully automated this whole process.
So whenever you want to find whether particular parameter is available to union or whatever, you can
just cover this and this group to distribute free.
So that's our goal for this video.
You can also automate this using them.
I did not, but this was in this case, we know that there is there were no user users, if you don't
know.
So we need to do that user order tables via this information schema.
So we'll be doing in the next few years.