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
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.
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.
- 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.
The following figure is displayed upon successful creation of your table:
Figure showing PHPMyAdmin after successful Table creation.
- That's it you've learnt how to create database & table using PHP MyAdmin.
Click here for Insert, Edit & Delete operations.: Please