So all in advanced quite in four I'll teach.
If you are it says there are different files but not my kind of files or what I need to do is maybe
I'll change directory.
Go back and go back or change directory to the colon.
Right.
OK.
So you're allowing me to do that.
It's quite ok.
So what are you going to do is instead of creating the database out there in the OR in the same thing
I can just put all you know I'll just put it in well that's quite weird though.
And allow me to access
OK anyway so I'm just going to put it in C colon.
C colon slash
slash school levy.
Ari you know let's see if this works fine.
Control Chip 10 unable to open data file OK.
But Swannie create one colon or some database file isn't right.
DE indeed quite some projects advance quite in priority databases.
There is the database file.
So why you might not opening.
It's OK.
So you fyce If I open up a terminal which is going to be quite algea
OK so this is the virtual environment you're working in.
Let's call so if I would open that in normal the saying it's a fight not terminal that's in the command
prompt.
I would say C D.
OK.
Cannot find the parts specified.
OK so.
So you open it up or let's read it directly using the program itself without having to go through the
hassle of so screen or not creatures or like that.
Right.
So we created one school school that DV write that has already created all these tables all of them
are already created.
Now all I need to do is I need to read that now how why the right.
How do we read from each of these databases.
That's my major question.
So this is all let me say in databases let me say a new quited file right there in sort of.
So I'm going to see now reading from dieta beasts then you see reading from the texts now in reading
from the Daviess what am I gonna say is I'm again going to put it up to your import again the same things
simple escalatory right and create a connection
with the database.
That's school TV and whatever connection that I've created storing no cable connection.
And from the connection create a curso and Diskos can be stored in a variable cursor cursor talks.
Now I'm going to do execute right a query which is going to be what's going to be the query I want to
query you know select select star from school.
Correct.
And so this is the query.
Sorry I need to put it in a variable query in Oct.
Right.
So the Square-D and I just execute the query when I execute the query cursor or execute query that will
return.
Or just execute it.
The result will be stored.
To a cursor cursor docked fetch.
If I do cursor or fetch all and whatever the fat shaming of that will be their end result if I print
the cursor also sorry print the result in the result.
Sorry all.
And let me say print up close the connection connection dropped pulse rate close connection and that's
after printing the results.
So let's do that control should f 10.
No such table scope readings from data step b y so in data so-called DP There is.
There's one school Dalty.
OK so connect us to connect.
OK just a second because oh Sinixt are from school there's no such Stabil school of course.
That is a school.
There is a table.
College students a table of teachers.
So what we can do is we can do both.
Print this result.
Sorry controlled set lets say print
student details and then execute the query to get all the students.
Then print teacher use
it
and let me execute the same thing except except I will be having
no having instead of star from students.
I will say Silex star from teachers so certain details all of them are printed OK but Kennie's you see
the deals are printed one after the other.
They are in a list of top notes.
They are in a list of all scrollable name gender and none is what Nanna's.
I guess the GOP was not.
So this is a list of Stupples So all the certain details are there one after the other.
If you want to print all of them one after the other or if you want to access any one of the sort of
details you need to save for for every student.
Same result for every student and results.
Trained students.
Great.
So that's how I have a student or I can all say over here for every teacher.
End result friend teacher so far under control chipped in.
First friends all the students and their friends the Stupples of one of each.
Now what I'm going to do is instead of getting all the students I want to know axes or leave those students
who are you know only the female students I just want the names of those who are female or let's say
only the surance which are male.
Again it just ruins me.
I just want to execute that.
OK so how do we do it.
Then I should say select star from students where gender are equal to an agenda equal to.
Now comes the question I need to put this in.
You know I can put a single quote here and a single quote here then I can have a double quote.
OK so now insurgents can you see all the male students came up.
Re not the female student then there was only one male student.
There were two female students only one means in the first case of printing the result.
I don't want to print the result as a whole I just want to print each of those teachers she writes in
detail for male.
So in the other case I want to print the female specific star from teachers where gender equal to female.
So I need to put this in a single.
This entire.
So then they'll be really one.
If I put this male they'll be two teachers.
Which of them were me ISDN.
So these are the ways that you can use for accessing data from their parents.
Now never going to use the same principle for dealing with the checkbook app and putting up you know
data with databases in the chat or in the chat.
So rather than the next video where we make use of data when every client sends it there'll be stored
them in databases and X calling the access right.
So let's do that.