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.