So now we are going to learn some obscure Connery's other comments in this video and as you can see,
how connected to my local MySQL server and I would explain the interface over here to get a much better
feeling of undiscerning.
And you can click on this file.
You can create a new model or you can define your own database and a set of rules and you can open a
new query type.
It's the same like this.
And you can also open this up, open a square script, if you will have any comments written in a script.
And you can open that in the using this organized group and you can also open and you can also run a
script and you can also call the tabs and scripts.
So these are used for this opening and closing the scripts and you can choose the preferences if you
want to and you can do the home banners and the next minute placement, etc. And in this quarter you
can select the statements you want to execute either current statement or are the statements.
So you can if you want to open another current to that, another database which is on another computer
or any other part.
So in this server, as you can see this one, you can click on this admission, the same settings you
see under this server options and the tools you can configuration tools.
You can back up the connections and restore those connections.
So you can also use this scripting.
You can execute the commands here.
And we are not going to execute any scoops.
No, no.
What is click on this.
So these key ones are like metadata for this database.
It defines what columns are there, what tables are there and etc..
So these are the three databases that are provided in world with MySQL.
I start to use the PowerPoint presentation to display my school of basics, but I thought it would take
so much time because this my school is very long and also making PBT is I'm tired of this.
But anyway, I will explain from basics this obscure statements.
As you can see, there are two databases here, Sakinah and, uh, CIS and the works.
This is the main database used by this school.
And you can see these are these two are the sample data, which is a killer and the world.
To click on this Aramaki, you can see this database has been expanded and this inWorld database, you
have the tables, you score procedures and functions.
So these functions are to automate this school statements.
You can just call these functions and they will execute.
And you can also click on these tables.
And in these tables we will have the information in the rows and columns.
These columns contains the actual data and the rows contains the values.
And if you click on this city, you can see here the information it's telling you.
So in this city table, I have the schema as no country, Kurdish population.
So that means, uh, in this city I have some names contribute district and population to the same way
if I could to this country.
I have the name counterintelligence service area, and there is so much information about this.
So I want to display this data.
So how do you do this is first you need to use.
Use a four letter word, so I'm this my high school education to that means capital use and smart use
and capital is both awesome.
You either one.
But many developers use the capital letters for the school syntax comments like you select and so on.
So first, we need to use this word for a run.
This I need to click on this record to run this statement.
And you can see here, this is the log.
You can see the output we have that this useful.
And you can if you go right over here, you can see this is the left banner.
This is Breuker negating.
Have to click on this.
This will go off.
And if you click on again, it will really just give us a update on this, though.
Uh, you can see the click on this now.
It will vanish.
Now, if I click on this, it would reappear now in the same way, right there is the right window.
Uh, you can add excursions.
Uh, we don't want that for now.
I am in this, uh, to disappear so fast.
We have learned this useful.
So this database will be use it as it may not like this obscure condenser pointer pointing to this or
any operations we have will do will reflect in this database.
So we are going to learn select committee.
This is very important.
And what we want to do, we want to start started in a sense, all the columns and we need to see from
you on.
These are the tables you want to display from, let's say, city.
That's a city.
And I can see this program is, uh, every line ends with semicolon in the same way as you can envision.
Uh, but in the modern, uh, high school, uh, syntaxes, uh, even though if you do not put semicolon,
uh, this is Kirkman's gets rejected, but it's best practice to know if I click on this icon.
Uh, I can close this output using this, we don't want the output we want.
We don't want drugs.
We don't want only this output to expand this.
You can see the whole information about this table in the city table.
I have the illegal name column, country, district population.
This top heading is called columns.
You can see this is the column and this is this is this and this.
And in the column I have the values one, two, three, four, etc. I have the values, Cowgill, Conder,
etc. Connecticut district population as well.
So this is called one drop and this is called the horizontal values are called rules and the vertical
columns are columns.
And I started started because I want to display all the columns.
If I want to display only the column, I can say, uh.
So if I click on this one, I can see there are only the ideas.
So let me click on the star and click on this and I get the ah, the values.
Now I can just particularly sort of two or three columns by supporting them with let's let them come
up and just.
So I think the syntax is correct.
OK, now that's so if I run this, I will get only two columns verbatim.
And so these are the basic derivations we have in my school.
I can also say Sarac star from a country.
Let me execute this, OK?
There is a lot more information going on.
You can see, though, this is a country called name continent region service area and their population,
etc. As you can see, there is a value called.
So no value represents nothing.
It's just like placeholder to say that there is no information about this column and about this law.
So suppose if you, uh, have some information but you don't know yet, but we want to find out in the
future.
So in that case, you can keep the value so that others can understand that the value is unavailable
or it may be available in the future.
So it's like a placeholder if you don't know the value you can put here.
So these are the big databases available for them.
But we do not want the database.
We are going to create our own sample databases.
Let me call this output to create a database we need to go create.
Database and database, no.
Let's say students, so we are going to clear the database kada students at Mexica this.
And you can see there is no assurance that the best way to handle this, you want to click the button
to see the changes and you can see there is the student database.
So this is not highlighted, but, uh, the world has the ball ball because, uh, previous comments
we have used that use all the, uh, Quarrie that swing this world is in the, uh, accoustic.
So we need to get the students as an to we need to say we can do this great.
That the students are in a school.
You can put two hyphens and the space to create a comment.
So this line will be ignored.
And if you can this nothing will happen because this is a comment.
And this comment is very important in a school inflection point of view.
So I can say use students or I can just Double-Click on the students to make sure that this is actually
the best.
So I get on this one and shouldn't be going back again.
I figured if I double click on this world, it will be Comsec to know.
However, we will execute this, uh, statement.
You students don't worry if I use the statements Kuwaiti's or any other, uh, uh, language.
What are some recent statements are saying?
OK, now my students database is inactive.
It is always, uh, a good method to use the database you are, uh, performing.
I mean, this that I database name, uh, in front of whatever before the any changes go into this by
students.
Uh, this make sure that we are actually performing the operations on the students database.
So we do not have any tables.
Not this is empty tables, empty database.
We need to create the table.
Lets to do that the secret uh table.
We ritzier our table.
We need to put the table name that's uh in for.
And we need to select the types of columns we need to add into this info table.
So let me say open bracket and in this open bracket, we need to define the column values column.
Uh, better let's it.
So every student have the idea and the data for this idea is integer.
So I want to serve first the underscore name.
So we shouldn't have the first name.
And I can say where worker of 250.
This is like ASCII, sorry, NC you can see 256, uh ASCII plus extended ASCII values can put this as
it first.
Right.
This is the basic syntax of DIWAKAR.
I don't want to go in depth into these variables.
I just explain the basic values that are integers and workers.
And there are actually in the sense a lot of uh, uh, LNT characters.
OK, a student can have a last last name.
Last name is also where care workers sense verbal character and she can say open brackets.
You can see where various options were to differ.
And we have the first name, last name until the last three four underscore number.
For no reason right now, I can successfully cross this, uh, braggarts and put the semi current let
me execute this query for a fresh this.
You can see there is a table created in.
So we do not want this because I want I want I'm going to do this.
Now, let's start from, uh, Disinfo.
To see what other values are there in the info table.
Let me run this query can see there is there is no let up because we just created this table.
And what this is, this is called schema.
And also there are other countries and the concept Koliada diagrams that is into the relationship diagrams.
You can just map these translations using this relationship diagrams in a diagrammatically.
That's why this is this database, as is called Relational Database Management System RDBMS, because
we can, uh, connect these databases tables using these, uh, relationships.
So we will see how we can connect using the joints, uh, in the end of this area are within a few moments.
So now if I start this structure from info, I have got no data because we just created the table and
we have no data is you can see there is a different name and phone number.
Right.
So we are going to insert some values into this crew that I want to insert into.
I want to specify the table.
I want to insert I want to insert into enforceable and enforceable and I consider brackets.
And under what columns I need to insert, I want to insert our first name or phone number.
If I want to insert into all these columns, I can just simply say, well, well, you s and I should
do in order the values of the first row.
So I, I'm, I'm going to enter the first row that is ID number, let's say one comma and first term
to Nagasaki, which is my name.
And let's, let's say last night musicological nickel and then let's say for number one, two, three,
four, five and put the same in Canada.
So what this means is we are inserting into this in four tables and the values are one.
This goes into the idea and this now goes into this name and this nickel goes into the last name and
one to if it goes to the phone number.
So if you want to insert into only first name and the last name, you need to say.
Info off.
For first name and the last name.
Fashion for them.
I need to switch to only two values and the two are going to go into these two respective columns first
and last name.
So I don't want to do that.
I want to put in these exact values into this exact columns because there are four columns and the four
values of the first, and that if you exclude this.
OK.
I did not use the static statement to refer to the data structure from.
In four, so if I run this query, as you can see, these come this insert is has been neglected and
we got the first one.
Now, one, two, three, four, five.
So let's try to insert some more values, some morals.
I mean, let me copy this.
So let me try to insert the first two three.
For so let me add some of the students so I don't have any friends that say Acer is a laptop.
A sort of Strix.
And let's say 100.
And let's talk to the Navy's Lenovo.
It's a last name for this Runaway's Legian.
And let's you know, the phone number of this region is 500.
I'm just putting for one purpose and let's say Iesus.
And rashness, let's roll.
Let's say the very one, two, three, one, two, three, four ruffian's, so we are going to insert
three more rules and let's see.
And there you can go, there you can see the four walls have been inserted, first name, last name
and the phone numbers.
So this is the, um, basic the my escort clients are let us see some more.
So I have a comment on these comments now, we need to see some of these filter options from the statement,
there is a condition called bear.
And this word can be used to filter the options, uh, certain with this select statement I can see
are the results are the columns from the info where I can say it is greater than two.
So I can say it is greater than two.
If I select this for execute this now, I will see the output only with the rules that are greater than
two.
So we got the three fatalities.
So that's how you use the word to filter these ideas.
So you can also put the greater than as equals two to get two, three, four rows and you can put the
rest on articles two together, one, two rows.
And you can also, uh, put the rest then.
Less than two to get the first true.
And you can also put this greater than or greater than a than rather than three.
This is not as equals.
You can put, uh, exclamation as equals to to get decided not as close to three.
So I get the rules with the I.D. one, two, four and not three.
As you can see, one, two, four, and not so this is another form for the not equal to some of these
databases of Resident Getdown and some of these databases support databases like the obscure maybe actually
suppose less Democratic than audemars because of all this.
It's good practice to know these alternatives.
So let me show ID.
So I got this one botrytis, so this is how you can use the word and you can also filter with the ah
and the, uh, statement you can see and, uh, let's see.
The for no less than a dozen.
So what this means is we are starting all the columns from the info table where it should be less than
three and also for no less than a thousand.
So if I execute this, I get the second and third this and can be used to a union, these conditions.
So this is one condition and this is the second condition.
If only both conditions are true, then only this output will be displayed.
Otherwise it will get a blank output based on these statements we have given, based on the conditions
we are given.
Let me ask you this.
As you can see, two and three words, because less than not equal to three and also for no less than
two.
We got these two and you can also put the other.
And so, as you can see, it is less than or equal to three or four, no less than dozen.
So since this I.D. culture is done, this photo has been filled.
But why this has been displayed because the phone number of this group has been one to three and it's
less than today.
So that's why we can we got this photo also.
So that is how you use the R and the end.
And.
You can use the color distinct.
So is that a distinct.
So there are no any repeater values of this, so just you can also say they are using their distinct
and OK, I have made the mistake a gaming laptops name is Predator.
If I want to make a bet this value, I can say.
I bet.
A bird in for updating for the world said the last name is equal to where they want to, I want to see
change that strikes into the Predator because there is a gaming laptops name is Predator, and I want
to change the last name.
The calls to prayer there are so far this comment, this is a very dangerous comment because if we do
not give the condition, it will apply to all the rules.
Face this attitude, this one, this predator will be placed under this strict region and rule out this
radical.
That's why this is very dangerous comment.
And you only update this.
Use these statements very carefully and also put where and I want to share ideas close to two of every
single is that you can choose whatever you want.
I want to choose the idea for run this.
So it says that record you are using, save a bit more and try to build a world without work.
So this is like my school, save more for our patients.
So patients, you need to.
What we want to see is you need to say.
Said, Yes, Kule.
Save.
A bit is equal to zero.
So you run this.
And now you can see so after setting this up, there was as good as Alphabet's physiological.
I actually ran this set up as you wish.
So my are Strix has been replaced by rewriter.
So that's why you can see this is very important to keep out of their condition.
And if you do not put that, are the will be the replaceable predator sort of Miklós this.
All right, I think I said are the basics.
Now let's move on to the joints so I have a few more set theory in mathematics, like, yeah, union
B, Section B and disjointing very, very easy.
So don't get confused.
I will explain in a very clear manner that first let me
display the results of the info table.
We have the I.D. of these students.
Let me create a new database.
So.
OK, let me create a new database to create the tubists.
Richard Marks.
So why do not clear that up as we can simply create another table, right?
Ritsa, Gruyère.
Creer.
Bill Marks, so what we're going to do is we should have this one column, uh, like equal in two or
three tables, then we can join those two there was using the same column.
So let me explain this.
So create table marks.
And I want to say it by putting the point and I want to say, uh, Marks.
And the are also integer, so me correct this.
You can see so there are two levels, let me go and insert somewhere else into this.
Inserting tool marks that values.
Well, you s let me go and insert 81, that cigar that marks 100 marks, so let me copy this in such
statement and post multiple times.
So I want to create the second lady and so Marks is to three hundred thirty marks is equal to two 200
and now I'm going to put the idea.
It is not enough in for, let's say, eight to eighty, eighty, eighty and how the monks 900.
So let me go and execute this.
She can see are the statements have been executed.
And let me start from.
Marks.
As you can see, there is I.D. one, it is one, two, three, and the marks, 100, 200, 200, 900.
Let me also display the info.
So these are the student names as these are the students, one, two, three, four, and previously
we have the marks and observe only the authorities.
We have one, two, three, four, and the details of the students if you exclude the marks.
So we have the I.D. one, two, 380 and the marks.
So what we can join these two was using these marks.
So I will show you how to do the joint.
So these are some types of joints.
Those are inner join.
So inner joints in the sense that the two days and the already displayed results, which are common
in those tables.
So what are the common in these two there?
Was it one, two, three are in this table.
And also I one, two, three are there in total.
So all the disparate results, which are the commonality.
So inner joint is like a intersection B.
In Chinese intersection B.
So I will show you what is here and what is being so fast, I want to see a select.
A star from.
For now, I want to apply, not join, I want to say.
Inner join, I want to join in for table with Mark.
And now I want to say on so on what basis, on what basis, your journey, these two tables on the Idy
basis, I am joining these tables because the article is in this info in the box.
So I will say.
It's.
So that's so you can you can access this table using the students that info and students dot marks,
so it's students.
Not in full or not, Heidi, you can access this individual column using the student database and enforce
the will and the article is equal to.
Students taught and marks, not I.
So I am I want to join this info and the marks on the basis of this I.D. it makes good this.
So I have some.
Oh, I think I should.
OK, students.
So there you go.
Yes, I got this what I have done is I said I want to order this from me for where I need to get all
the resources that are matched with this marks.
So what are the results that are my trademarks?
On what basis it is?
So I have only three ideas that are mentioned in this info table.
And amongst those are three areas.
And you can see the three and the first number on the phone number.
And also I have joined the march to march here on the radar because this is a table we have as human
left side and this is the right there.
You can see this is these four sorry.
So this these are not left in photos and this right.
Uh, Tukaram Soldat, Mark's information can see it and the box.
So this is a intersection B, so this is the year and this is the beat.
So on intersexual we got only the matter is the are one, two, three.
So this is a joint.
I hope you have understood.
Now let's see the left.
The joint left.
So what this does is it's like year on year when it's been union in the Section B. So what is that?
What it does is it would display all of the info are the columns from the info table and also only the
matching where you saw the marks.
And if there are any that does not match, it will put the dollar values of I execute this.
And as you can see, it displays are the columns from the info.
There are the currents funding the info.
And you can see there is a photo issues.
But in this market, we do not have a default.
We have the idea.
So in this case, there is no default.
That's where it has put the null values.
So it is with all the value of here and only the matching value of being the so called innot left to
join.
And if I say right joint, so now you can get the right joint it displays are the values of these marks
and only the matched results of this info.
And if there are any leftovers from the info table, it will be replaced with another.
So this is the joint if you change it to rejoin.
Hourigan sees these values will be filled with data and the marks and these values internal to execute
this.
OK, now, if you can see these are the rules of these marks, they will have been successfully got
and since there is no ideate in the info table, we got the Navajo's.
So this is the right to only be and also match results from that.
Yet it will be when you say intersection B minus the union intersection B, so there is a card for our
joint which will combine every various.
Squid, this.
Ocurred, this is floatplane.
OK, I don't know why I'm getting this are so full of.
OK, if I run this floater, then I'll get that for Riley and also I'd already but in case it will join
the whole left and right.
So that's what this is called.
Basic Search.
I hope you have understood even I suggest you do practice all these statements.
You can also Google them and practice the basic, uh, yes.
Good qualities.
And even those who do not practice just understand this video and it will be very much helpful.
A further injection.
You can do the manually, the you can join these tables and you can also union disturbers.