Site5 - Built For Designers & Developers MENU
Home  ›  Databases  ›  PHPMyAdmin  ›  phpMyAdmin: Creating tables in a database

phpMyAdmin: Creating tables in a database

Comments Off on phpMyAdmin: Creating tables in a database

This tutorial assumes you’ve already logged in to phpMyAdmin

Now let’s learn how to create a table within a database

Select the database here
pma_newtable_1

Enter a Name for our new table
pma_newtable_2

Then enter the number of fields this new table is to have. Click Go
pma_newtable_3

Now enter the details of each field within the new table
pma_newtable_4

We also want this first field to be the Primary key that will be automatically filled in (auto_increment) when new entries are added to the table

The first field will be called id, and it will be an integer
pma_newtable_5

Selecting this option makes the id field the Primary key in the table. You can also enable auto increment by checking the A_I check box.
pma_newtable_6

The remaining fields will be CHAR (character) fields. Be sure the length is set long enough to accommodate the fields
pma_newtable_7

When finished, click Save
pma_newtable_8

That’s it! Our new table (details) has been successfully created within our database.

This is the end of the tutorial. You now know how to create new tables within a database using phpMyAdmin

Still have a question? Or need help?
See an error in this article or want to suggest a missing topic? Please leave us a comment below! If you need technical support with your account, please email us, chat live with a representative, or call us!

Comments are closed.

Money Back Guarantees
Click to verify BBB accreditation and to see a BBB report.