OK so that can give me some sign some sort of some you know create table.
So these are some commands which are specific Kresge like if you wish to have a look at them.
They are their options.
You can have a look Eski light escalate commands.
So these are the commands that you can deal with.
Charles points one of them which we'll deal with.
Or you can just go to.
You can just go to escalate towards the command line shell for a satellite and it gives you all the
documentation for the same where it says if you want or you can.
You can just create a table by saying create table.
And the tables name should be there that is Table 1 and you should give the name of the columns inside.
So the names of the columns in that table one and two.
And what is the type of the variable that these columns will hold.
That needs to be given you vodka for Strain small and for something else.
OK.
So you have a couple of things and then you insert into these the values.
So we're going to deal with that in detail as we as we start up.
OK.
So we are going to lead.
So let's start.
Let's start up with this and let's start with the commands.
OK.
So we are going to say.
Let me just put it up.
Let me just put it up out here.
So the company that table like Mercy create table create table what I need to give a name let me say
the name of the table is employee.
OK if I put just a semi-colon I actually put a semi-colon after every reskill light statement.
Other than the ones which are dot helper dot exit or dot databases or something like that.
Tables.
Now you don't need to present every call for them but you do put a table for everybody.
Stylites into every valid as a light command.
So you say there's an error why.
Because you cannot just create a table but you also need to say what kind of columns are there in this
particular room table employees want you to put them in brown brackets and then need to say the kind
columns that you want to employ.
So let me let me say I want every employee should have an ID.
OK.
Every every employee should have should have a first name.
Every employee should have a last name.
Every employee should have you know something which defines your salary and something which defines
their.
So they have their first name they have their last name they have their salary and also you can have
something like they're things like the employee they're OK they're email they're in the store and.
And of course there you can store that data.
But.
OK.
Date of birth or date of joining or something like that let's just have just one.
OK.
And let's say if even if now if I say enter it will give me an arrow.
So it didn't give me an error but by default it takes.
If you want to see the tables you will see the tables.
And there's an employee.
So if I select star or if I if I want to see what all are there in tables you know.
So.
So if you can right there select star from employee that's as you can see select star from the table
ones that will give you all the columns but OK the columns nothing is there but at least the name of
the headings should be seen.
So irritated at her on Dot header on and then do the select star from imply.
Oh so there's doesn't work out there for reasons.
OK.
So here in this case it is on.
So it gave you the you know it gave that particular command and it made it on OK as we go ahead.
Let's understand a few things out here.
So we created a table and the.
So that's one thing but second thing that we need to understand is we also if you want to drop this
particular table you have to it drop drop table.
An employee I can just say that Tropp table Employee and now if I say Doc tables if I say that tables
there there's no employee table because I just dropped it but now I want to say I still want to see
just employee but I also want to say what should be each of these.
Should be of what type it should be of type in teacher OK should you have type in teacher first name
should we have type of CAD of around 20.
OK.
Last name should also be right care of around 20.
Right.
So salary salary should be should be in.
OK.
E-mail should again be over Carol.
We're on 20 DRP should be of what type and have a look.
There are different types of data which is which is given here you can have a look output format or
something like that.
Just a second you can have a look.
So you have text real small NCSA we import export Export with Excel.
You have a lot of things which you can do to export files.
But so if you were the one to have a look at the escalate options where you have different data structures
or different you know different things that you can look at.
So maybe in the documentation you can just just go ahead have a look for the documentation and there
are all the documents there are you know the alphabetical listing.
OK.
So what you can do is you can go for the if you go for the overview documents it's about the overall
programming interfaces is escalating five minutes or so.
Escalate syntax is the rescuers and that's ok so.
So the programming interfaces is what we need to need to know.
Right.
So this is side of the school a skylight in five minutes or less so we could just talk.
So we just did about escalator DV and you have or you have an estimate for you know which way you can
connect using C-code.
That's not what you want to do though.
So if you want you can just write.
You know whenever you feel you want to come on.
Escalate command which which is a query.
And you want to say escalate date you know good times syntax or something like that.
So if you want something like that you have a daytime function and maybe you can have a look at escalator
to work itself which which takes date locate supports file date and time functions.
One is data itself.
So data takes a time string.
You can have that.
So you can have a date which of course you can have it so you be again going to be something Colus DBI
is going to be date.
That's it.
So it's going to be I've typed it and then you might.
So there are certain things which are which you want it to be so Id of an employee is going to be the
primary key which will recognize them more which will you know mock him so I can put that as a primary
key.
Also I need to say this particular primary key increment every time an employee comes in or is that
fit into is actually play I should increment it.
So this must be very clearly stated in the auto increment.
Now there are certain things which should not be null which means that you should be inserted for each
of them.
So for example if name first name it should not be null.
Right there not now.
OK a last name can be null No worries salary also may not be of criteria to put in the database for
now.
Email also we can say all right not null and no media 2 you can press not.
No sorry if you don't want it to be.
You have to put it not only if you want it to be compulsory.
So don't put a not NULL for email and salary because.
Because we have the choice then of not putting it up.
It's the last names that end up.
So it says that is an area near the autoincrement syntax.
So primarily so in teacher you need to say our increment let's say disco Yes you put it on us go for
our increment and they have the primary key.
OK.
So these are a few things that you have any create a table.
Now if I see what tables it will give you this thing and if I say that's Bema backi my it will tell
you the schema of the table Employee that you just created.
What was the scheme all the same.
OK so this is about creating a table.
Now let's see how to insert values into the data.
OK.