Hello and welcome to this video and this video, we are going to create a database, we are going to
add tables into the database.
We are going to access and add records to the table with the help of a school.
So let's create the database first.
So to create the database, you will have to make sure that you write the proper name of the database.
So you have to select the name of the database.
I am selecting you admire is a name of my database and click on CREATE.
So once you create your database, you will land onto this page.
This page is a create table page if you want to create table.
So you have to write down the name of the table and the number of column you want into your table.
So I want three columns and the name of the table should be notebook.
So you're right.
Click on Go and then once I get on go, I am on to the next page, which is the structure of the table.
So if you remember that I selected three columns, so I got three input filled over your 123 wherein
I'm going to write three column names.
So the first column name I want is serial number.
So I type serial number.
The second column name should be name and the third column name should be attendance.
As an example, I'm going to replicate the same table structure, so the first day that I should be
in, I want serial number to be an integer value and the last two to be very good.
If you don't like the length and if you try to click on go, it will say that you need to select a valid
length sword.
So the maximum allowed length for the serial number should be ten.
And for rest, while I'm selecting 50 50, you can select anything as per your requirements.
This is not compulsory and then you can click on go.
So if you see that my table notebook is been created, if I go to ask you will the query is auto generated.
That is select start from notebook, which means select star means all the records from the table.
That is notebook.
And I hate to go.
So when you go, you will be able to see the table, which is an old book, so you're I have not inserted
any record or values into the table, so I am seeing only the structure of the table with three columns
that the serial number, name and attendance.
So now I want to insert the value into this table.
So you have to go again to the school.
If you do not know the syntax of insert, no need to worry.
You can click on this button insert and you will automatically get the syntax of the insert query.
Now, I'm going to be adding values to this new book table, so the first record should be one is first
column is serial number.
The value assigned to the first column number should be one to the name.
It should be written for attendance.
It should be present.
This should be my first record, serial number one name to and attendance to be present.
Make sure that when you select a record and when you insert that value into the query, make sure to
put it into the single core so that it works perfectly and you have to go.
As you see, when Roy's been inserted into the database now, I'm going to be adding two more records
into my table.
So as you can see, if I now select Start from notebook, so I see one record which is inserted right
now.
So now I'm adding second record that is serial number to name Shifra, and attendance should be Epson.
Click on Go.
OK, great, so second record has been inserted into my table, if you want to see the table again at
the very select start from Table Belém or else you can keep on adding the records once you are done
at the end, you can see all the records which you have inserted.
So I don't go.
I am done with adding three records.
So now I'm going to see whether the table is been updated or not.
So select start from your table so your eye can see if the table is being added with three records,
which I have added.
So, yes, you can see three different record has been added to my table when you click on venue, very
select star from the table.
So this is it for this video.
We have learned how to create a database, how to create a table, how to select the data type for the
particular column, as well as how to see the database.
What all you have created using a very select start from table is the very simple syntax of this school.
Thank you so much.