Tute 6 : Create a Database in Mysql Database

This tutorial we know how to create database in Mysql Database.

Now we create a database for our website. We use Mysql Database for this site. Take a new tab in Google Chrome. Write “localhost/phpmyadmin” in address bar. Then press Enter in keyboard. We see this look in web browser.

Tute 4 Pic-1

If we write only “localhost” in address bar we see this look. Click your Language. Then click “phpmyadmin” who show in left menu.

Tute 4 Pic-2

Now we create a new database in phpmyadmin. So Click "Databases" in top menu.

Tute 4 Pic-3

Now we see new look. Write a name in “Create new database” form and click “Create”. I write my database is “tutedb”.

Tute 4 Pic-4

Our database is created. In left bar we see our database name in the list. We click our database "tutedb". In right side we see two blank form "name" and "number of columns". Now we create "Table" in our database. So we write a name of our table and write number of columns of our table. If our table has 3 columns we write 3. I write my table is "tute" and number of columns is 4.Then click Go button.

Tute 4 Pic-5

Now we see new look. Here 4 line blank form.

I write 4 column. First column is id. This is Sl number who increase auto such as 1, 2, 3, 4… etc. 2nd is Headline. Third is Description and fourth is Category.

We see here 4 line blank form. First is name, 2nd type, 3rd is Length/Values detault collation ... etc. Now we fill up this black form. At first we fill the first line. Write “id” in name field. In type we select “INT”. This filed default select the INT. Scroll the horizontal bar and go to right window. We see “A_I”. A_I means AUTO INCREMENT. We check in the “A_I” only first line. Then we nothing other blank field.

After that we fill up the 2^nd, 3^rd and 4^th field. In 2^nd field we write “headline”, 3^rd is “details” and 4^th is “category”.

In “type” we select “VARCHAR”. Because we write here text, symbol and number. In 2^nd, 3^rd and 4^th line we select “VARCHAR” in type.

Then fill up the Length/Values. This field for number of Character. In headline is few character. So we write 100. In details write 10,000. because description is very big. Category field we write 10. We will make category is simple.

Our filing is finished. Other field we keep blank.

Tute 4 Pic-5-1

Than click the Save button in bottom of page.

Tute 4 Pic-5-1

Now we see a new table in left panel named "tute". We click the "tute". Then see new look in right side. We see 4 line Id, heading, details & category. In id line we see “auto_increment” in “Extra” column. Never do not write id in our form. It always make auto and increase auto.