Here we've been since the last video we have done creating the table by using a square like tree.
In this model we are going to create table with posterior square so for that one.
First of all here had the item code from the last video.
And now we go to the idea terminal but it's still not OK.
Maybe it will get fixed by today.
But we have determiner so let one first of all aim to give you a situation like the one that we have
considered before like putting some stuff in your drawers.
Then the procedure is like this but you need to go to a drawer open that one as you could do a process
be sure and close Denman.
Now what if I say you that you need to put the stuff in another drawer.
How could you do that.
So you need to again find it open open that one execute be sure and close Dedmon insured deposits is
nearly safe.
You need to go to the different bank like the position maybe in a different room different house or
maybe somewhere else what I need to see you here is no not matter that what kind of database you are
using the default one like this one or any other data.
The ESC will light sorting the Eskil commands are seen because as I've told you a skill is just generally
server query language so that will be same.
The commands will be seen in all the cases.
You just need to change the addresses of the databases.
All the things will Boxee.
Let me show you that million or so for that one.
I'm just hoping this one and pasting it here.
But before that one let me have a look at our database.
So this elephant icon you will find on the launch pad like this one on the window bar individuals.
So when you click that one it will open and if it did not go to that icon and create new P.G. For me
then you will get a base like this one that you need to add to the password you had created.
That is post G R E S I have created in my own okay and you will get this interface.
Here to check your databases click on the servers so that it will expand and then you will find all
of the databases that you have created.
So here I have four databases that I have done here for simple examples like the one venue create a
simple database how will you create first thing is just click on this database just like selecting like
if I have selected this one tables this No no database go to object create database and then you will
find options like this one name that and see the one we are going to take an example in this video data.
Base or just data because we also have a database here save you will find here.
This is an unpublished database so this will be game like these published.
Then you get some data in that 1 after that it will appear like this one when you extend that one he
will find different options out of each in schemes you will get your tables.
Here we have this one tables below I did not have added something in that one but here in this one data
I have created a basic example Dell table seemed like the one example we are taking.
It causes two columns.
Rule number Neiman Marcus so you can just create table by selecting table object and create table.
But there is something weird you are not going to handle your database to a user who is using your program.
Maybe use computer or some of it as you are not going to do this thing.
So I'm going to teach you that how you can create table by using programming.
Otherwise you would just do that one because you need to connect this program or your interface that
you are going to build with your database.
Not like adding the design database again and again and using the program.
So we are not focusing on that letter that is but very easy.
You can check that one.
Now how we will do that the first thing you need to do here is just in your database you need to create
a database in which you are going to enter this stuff like I have created a data tool right now.
So I'm going to consider this one and now here on this one the disclosure I had just only change two
things.
First thing is the address of my new begins to draw.
And second thing is this liberty because we are not working with Esko lied to right now.
We are working with a different liability so that liability in this case is known as Psycho Beach too.
So we'll be focused on dispelling.
There is no edge in that one is just psycho beachy too.
And there are more libraries also like PGA eight thousand and you can just google out libraries for
interface with post jihadi esque aerial and you will find the alphabet mentioned the Python 3
we just add bytes and not so with
you.
So here whenever you check annual diva site most of the cases they will be listed everywhere.
Like this one cycle P G two that we're currently working with PGA thousand B by Post ask well.
And there are a lot more.
So we are going to work.
Psychopath you do and this is a library considered one of the hardest to install because you will find
an to install in that one.
So we will go installing this one because this is not by default into a computer.
And I will teach you a simple matter to avoid issues like this.
Let me first give you the issue.
Just simply you can install any library by using pip install psycho P.G. do.
This is the name of the library.
Just like the Metro Lucy won't be a hit return or rent on Windows.
You will get collecting psycho package then loud chatter sewing showing some common Python failure with
error code one.
And also if you do something like P capital because the library name is with P Capital and psycho busy
too you will again get this letter.
But if you are getting this library installed in your computer then that will be very good.
Just give us some part of this video of true up to which we are working on this one.
Not for those who are getting smarter.
Either they are on Windows and on Mac they will get DNA.
So to solve this urgently the matters are just google out celebrities and search for that one and this
will take a lot of time.
Sometime you will not find the library and then many shows like the department.
So I have a general and very simple solution for these kinds of issues.
What you need to do is you need to work with Conda or against Anna Nicole's condom distribution is something
that contains most of the libraries and every library will get installed in the condom distribution
even if they are not good.
In this one I mean also just do corner install and then just write cycle b g two.
This is the reason even when I am working with the data science I'm doing colder distribution most of
the time.
So because this will install all the light it is dead.
So you just need to wait for the file and it will collect it and install the LAPD would solving environment
so I'm just skipping some part of this video and delay to get install and check if they have a deadline
so you will get this option just cried why he didn't return it will extract packages and just take a
little time maybe go with that.
Now the libraries install.
If you go to the Anaconda now we had this one all day long let me show something else.
If you do Python 3 here that and tried to import psycho busy too.
You will get this imported here now.
This is really a very simplified the same you will get on the Jupiter notebook but it worked there so
I did not need to show you that man now.
One more thing here.
In case you are getting more do not fun because maybe you will get this one even after installing this
thing that the model is not found.
So in that case what you need to do is first check on the Jupiter notebooks whether this one is installed
or not.
So it may be possible.
It really get not installed in your computer.
So do check all that man go to Ancona.
And check into Jupiter notebook.
Installing these like bridges by just import psycho PGD to shifted on they would get this sun inputting.
Now what about those cases.
Let me first close this note book a page because I need that but only know what to do in that cases
because that may also be possibly two cases here will new to this one.
You will get it.
So just go to the anaconda files by right clicking here right click and not right click.
Just come on and click them so that their files will be shown like this one and they are generally available
in computer disk and you will find an idea of getting this one but you will find that Anaconda somewhere
in your local drive.
We had to.
And in windows you have this one in local D C maybe because that maybe your windows drive.
So in that one go to library search for site go P. G to they will find some folders containing the liabilities
and getting these for does
David.
Here.
I'm not getting this folder because mine is maybe stolen main P.C. because I'm getting no entity importing
that in Python.
So again for those who are getting added you will find these three folders there.
I will try to include these folders with the modem because I'm not sure whether we can update these
or folders one day.
You read me or.
But still I will try these or otherwise I will try to provide a link.
So what do you need to do with these folders is just copy these folders to one end commodity and this
procedure.
I'm telling you by so much attention because this can be helpful in any case wherever you are getting
issues in importing any library based them on desktop and just change here.
The directory CDE desktop and then by turn 3.
Import cycle PGD do Daily Eagle if I just remove these from the index top then in that case let me show
that also.
Just this this and this command delete and I will try this command again.
Binds and 3 input cycle.
And I'm getting no error so maybe my computer is a smart it has already installed this.
So that's why I did not able to show you the errors but I hope you get that thing if you are getting
the Arabs those who not getting them.
This will be very good for them and you can apply this method again for any kind of issue with the libraries
because installing labeled it is a simple concept.
You do not have to provide much time for them.
Now let me move to a creating a table so the cycle page is now installed.
You also need to change this one with psycho beachy David Goldman and to also the last thing you need
to change here is this headdress.
That is the main part.
So just remove this part and tried a few commands here.
First of all.
Any school library soda any school language common is all visited done in between quotes.
So this is one of the things that you need to focus.
Maybe I have also told you with creating the execute.
Come on.
They are.
We have also done that one in quotes so make sure you are adding quotes them.
After that when you need to pass a few parameters.
The basic demonstration for that one is like when you have to draw it at your house then you are familiar
with that one.
Now just assume that is not possible however but still assume you have to put some down any door that
is present at someone's as home.
So you need to have their house address then they are users like who is the owner of that house and
then the door entries.
So let's begin with that.
First of all database name just like the house address.
We have data too and that will also be passed in courts and him.
I have used double quotes and inside that when I'm using single quotes because if you will do double
quotes here python will get confused with this one and this one it may consider this one as a closing
of this one so use different kinds of quotes whenever you are using quotes inside quotes and finding
using quotes here because we are not going to use your mind that but to be sure with that one coal mine
is not required in the connect.
Come on.
Never so that's why I have told you focus always on commas in quotation marks only day will be the source
of error in your program while working the databases after let me have this one.
Then just to use a name.
This is the go on you will all those required in any of the database the database name user name that
is both key areas in the case then password complete password and that again boast G ideas after these
three common things you need to pass do more.
First one is known as the port which is if you remember we have 5 3 3 5 4 3 2 and oppose it from 5 to
2.
That is easy to remember.
Hey forget food after that one last thing you need to pass host that are you working on line or you
are working on local host.
So here we are booking a local host so just local hosts.
Also you will get this host if you are a plus about a safari they are this thing.
Then you click here.
This one is a local host not online one because you do not have as GDP people kind of address.
The protocol is not included there.
So this one local host get H1N1.
So just local host.
Now we are done with this.
Just save this one.
Go to terminal exit.
This one now.
Python 3.
And what's the name of a whirlpool.
I'm their DP to not be late.
I hope I don't get an.
They read all of.
So decode is successful.
If you now open your this door closed below that one but I think that one is a daily looking go to database
too.
So you have noticed this one now color is changed because we have some data that skims tables and in
that one if you check the column there we have rule number name and marks the one we have included here.
Rule number name and marks.
So.