/* */ Click to Join Live Class with Shankar sir Call 9798158723

Create a database and table in MySQL ?

For performing any query in database, first we have to create a database with any name and then a table having table name with required column created.

Create a database in MySQL


Step 1:- Enter localhost/dashboard in url to open PHP myadmin.
Step 2:- Click on PHP myadmin.
Step 3:- Click on New.
Step 4:- Enter database name and click create.

Create a table in database.


Step 5:- Enter table name and number of column you want to create.
Step 6:- Click on Go.

Create required fields in table.


Step 7:- Enter the names of the column.
Step 8:- Select type of the field.(in case of varchar you must need to specify the length.)
Step 9:- Scroll down and click on save.