Now insert values in the table what we can do is we can insert values by saying we can we can just Grito
we can just use the command Kalas insert so insert into employee.
That is the table name you need to say employee insert into employee and you can directly insert the
values if you want to and so all of them.
But if you just want to insert selectively like say for example I just want to put a last name.
I want to put the power to put an email and I want to put that up.
I just want these things to be put up OK.
I just need to say and sort of employ and I can select these three columns and I can see just ABC columns
I want to see what should be the values corresponding to that.
OK so first name I need to put in string.
I need to put in double code I need to save the string.
First name is going to be it's going to be c let's say X Y Z.
Email is X Y Z at company dot com.
Right.
So that's also a strength.
And let me say finally TAAB that's the data.
But there's going to be a date but it's going to be let's say in nineteen Eighty-Four
1984 you know 18 and sorry it's going to be let's say.
So five and 80 and then close it up with the semi-colon.
And so you first the goal then a month then the date.
So that's how the GOP got start.
So that's about one employee if you want to insert another one let's say and sort of employ values instead
of x y z.
Next CPQ or this time I want to even put the last name so I can put an L name come on you know P Q R
can have p q p q r s t.
Great.
And then this can be just P-Q are at company dot com right.
And the date of birth.
Here he was born in 1989 1994.
OK.
And yet.
That's it.
What he was saying.
OK let's see.
And so now the FY if I say select r Let me answer one more insert into employee and sort of P-Q or it's
going to be x y z.
But he has the same surname as the earlier guy in this country.
Email will the ex-wifes here.
Compre dot com.
And this time he's from 1974 and Mundus he's from 8 Tater's 50.
That's it.
And so now you can just have a look at you know if you say top tables we'll just give you the table
name.
What if I want all the columns in that table I should say select select all from the table employ so
I can have multiple tables.
So as you can see X Y Z then it gives you you know nothing nothing and then x y z a complete dot com.
So it gives you the name Kenichi ID's their name is your name is your salary is your email.
You use you.
So it gives you even though hetero's for each of them if you're not aware of them.
So it gives you the TAAB GOP it's just putting up though it's just putting up the year for now.
That's OK.
OK.
So these are a few things that you need to know when you come to escalate the levees.
Now after we go on deescalated abuses we need to go on to something called us since we are learning
about this delight right.
If I want you know if I want all those employees you know rich are richer richer having you know something
like those employees.
OK.
By the way have IDs are incremented right.
OK.
So I just want those employees let's say who did I have to x y z.
So that's OK.
I want you know those guys whose age is about 25 or something like that.
OK.
Or if I I just want the date of it.
I don't want all of that right.
Or something like that if I want to do something where you know I want to deal with the IDs or something
like that then I need to deal specifically with a way to where I can say well OK I can use the concept
of where OK here now there's nothing that you can do you can probably put up or do or something like
that.
But if you want to you know if you want to exit this particular database you could just sit down is
it ok you can say on exit.
And after saying don't fix it you can just come out of the escalator.
Right.
So this is about how you can do with databases and how you can do this collated a business and how you
go about it.
OK it is quite simple this is quite not quite complicated and stuff like that.
Now what we're trying to do is we're going to create some bindings between the Python code and this
database.
That is what is our next child.
We need to create a binding bridge and that means you create a connection between them.
Try to bring the databases and then get some data from them and send data back in such a way that he
could store them or he can access them or he can work on them as and when time comes.
All right.
All right so what are you going to do was let's create Let's create a pilot file as we can see here.
We're going to create a python file out here.
We've already created you know a package that is set up the Senate where we're going to have a code
written in order to connect our architecture writing code with databases deal with databases talk to
databases access values said values populate it and stuff like that.
Right.
So let's do it let's let's connect to a database and then create a database connection and do it on.
So we'll do that from the next.
OK.