How to Create a Table in phpMyAdmin

Shared

To add a table to your phpMyAdmin, you must first navigate to the phpMyAdmin interface in the Account Control Center. For instructions on how to do this, see our article, Accessing phpMyAdmin in the ACC.

Creating a Table in phpMyAdmin for the First Time

If you have not yet created a table for your database, the Create Table interface will automatically appear in the phpMyAdmin interface.

1. Log in to the phpMyAdmin interface
2. In the right side of the interface, enter the name of your first table and select the number of columns it should have
3. Click Go
4. Fill in the column information for your table (Name, Type, Default, etc.)
   
   To add or remove columns from your table:

   If you added too many columns, you can simply leave them blank and they will be excluded from your table.
   
   If you did not include enough columns, you can add more by going to the top of the interface, select the table name and add as many columns as you need. Be sure to click Go when finished.

5. Click Save

Your new table will appear in the left sidebar underneath your database name.

Creating a Table in phpMyAdmin after Initial Table

Once your first table has been created, the method for adding tables to your database changes slightly. To create a new table after the initial table has been created, follow the instructions below:

1. Log in to the phpMyAdmin interface
2. In the left sidebar, find your database name and click New underneath it
3. Fill in the column information for your table (Name, Type, Default, etc.)
   
   To add or remove columns from your table:

   If you added too many columns, you can simply leave them blank and they will be excluded from your table.
   
   If you did not include enough columns, you can add more by going to the top of the interface, select the table name and add as many columns as you need. Be sure to click Go when finished.

4. Click Save

Your new table will appear in the left sidebar underneath your database name.