Creating Tables in a Database with phpMyAdmin

Reading Time: < 1 minute

This tutorial assumes you’ve already logged in to phpMyAdmin. Let’s learn how to create a table within a database.

  1. Select the database here.phpma-createtable-frame03_1
  2. Enter a Name for your new table.phpma-createtable-frame04_1
  3. Then enter the number of fields this new table is to have. Click Go.phpma-createtable-frame05_1
  4. Now enter the details of each field within the new table.phpma-createtable-frame07_1
  5. The first field will be called id, and it will be an integer that’s 4 characters in length.phpma-createtable-frame08_1
  6. 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. Selecting this option makes the id field the Primary key in the table.phpma-createtable-frame13_1
  7. The remaining fields will be CHAR (character) fields. Be sure the length is set long enough to accomodate the fields.phpma-createtable-frame17_1
  8. When finished, click Save.phpma-createtable-frame22_1
  9. That’s it! Our new table (details) has been successfully created within our database(demo1234_members) as indicated here.phpma-createtable-frame23_1


Refer a friend and get a $50 hosting credit!