MySQL Create Database

If you want access the data to php program then first, you will create a database in PhpMyAdmin.we will describe the steps which must be followed in order to create a new database, add a table with records, create a database backup and perform a database restore procedure.

You will start with the database creation through XAMPP:
If in your computer installed XAMPP...

xamp

 

The following examples create a database named "ssoftaid":

credb

 

Create a Table named "students"

tabwor

 

Create a Table "students" and in this following fields:

  • rollno
  • sname
  • scourse

savetab

 

After than look Table "students" of structure.

sowta

 

Now insert the value in the table "students".

inseval

 

Finally create database in XAMP look at:

db