How to create Database & Tables using PhpMyAdmin

In this tutorial you will learn how to create new database and table in MySQL using PHPMyAdmin. Creating a database or table using PHPMyAdmin is very easy. The steps given below will guide you on how to handle PHPMyAdmin.

Steps to create a database in PHPMyAdmin

1. The following figure shows your PHPMyAdmin interface, just enter your database name and click the 'Create' button to create your database.

   
   Figure showing PHPMyAdmin interface for Database creation.

2. Now to create a new table enter your tablename and the number of fields in the table, then click the 'Go' Button.

   
   Figure showing PHPMyAdmin interface for Table creation.

3. The next step is to create the fields, just enter values for each field name, type, length of the field, null option and mention whether it is a primary key or not. Then click the 'Save' button to complete your table creation.

   
   Figure showing PHPMyAdmin interface for Field creation.

4. The following figure is displayed upon successful creation of your table:

   
   Figure showing PHPMyAdmin after successful Table creation.

5. That's it you've learnt how to create database & table using PHP MyAdmin.

Note: Please Click here for Insert, Edit & Delete operations.

Absolutely FREE Web Templates
Check out these quality free web templates and download them without any registration or sign-up!

FREE Web Design Guide
From web design tips & ideas to HTML, CSS Styles, Fireworks & Dreamweaver you'll find all you need to know about effective web site design right here!

Quality Dreamweaver Templates
Professional quality dreamweaver templates in over 20 categories, starting at just $9.95! Instant download & easy customization