PHP Tutorials

How to create Database & Tables

Steps to create a database in PHPMyAdmin

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.

Please like, +1, link to and share this SmartWebby resource if you found it helpful. Thanks!