Create Database & Table in XAMPP mysql Interface

Create Database & Table in XAMPP mysql Interface

Create Database

First type url for phpmyadmin:- http://localhost/phpmyadmin/ or go through XAMPP controle panel to open phpmyadmin page Start------->All Programs------>XAMPP for windows---->XAMPP Contrle Panel The Fallowing icon appear in the system tray.

By clicking on it fallowing window appears.


Within the window click MySql Admin button. Then phpmyadmin page opens.



Then type your database name(my_database) press create.

Create table

After pressing the create database button fallowing window appears.



Here I have named table as biodata and Number of Fields as 4.Then press Go Button.The Next window shows like this.

Table going to create here I have included an extra field called "id" purposes are to add Primary key for the table and for adding auto increment. which are important in data base development.Primary Key uniquely identifies each record in a table so it helps to ensure against redundant data in that table. It is also used to establish a relationship between tables. Also used an auto column to ensure uniqueness. Next press save button to make your table. which appears as follows.

---