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

PHPmyadmin

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.

PHPmyadmin

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

Create required fields in table.

PHPmyadmin

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.