Web phpMyAdmin

  |   Wordpress   |   login   |   cookies   |   privacy policy

phpMyAdmin Create and Populate Tables

This tutorial covers the following topics:

This tutorial explains how to create additional tables inside a database and add data inside the table.

How to create new tables

To create new tables inside a database, open the phpMyAdmin tool, click on the Databases tab and click on the name of the desired database.

On the new page that opens you will see a list of all the current tables inside the database and a section named Create table. In that section, in the Name field, input the desired new name of the table and then select the number of columns that the table should have via the Number of columns drop-down. When ready, click on Go to create the table.

On the next page, you can configure the structure of the columns in the new table. The different fields there are:

After you configured the different columns, specify the Collation and Engine of the new table via their respective drop-downs.

When ready, click on Save to create the new table.

How to Add Content in a Database Table

To add records inside a database table, open the table with phpMyAdmin and click on the Insert tab.

Enter the desired data in the corresponding fields and click on Go to store it. You can see the newly inserted record by clicking on the Browse tab.