Creating Tables in a Database with phpMyAdmin

 

  1. This tutorial assumes you've already logged in to phpMyAdmin.
  2. Now let's learn how to create a table within a database.
  3. Select the database here.

    phpma-createtable-frame03_1

  4. Enter a Name for your new table.

    phpma-createtable-frame04_1

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

    phpma-createtable-frame05_1

  6. Now enter the details of each field within the new table.

    phpma-createtable-frame07_1

  7. The first field will be called id, and it will be an integer that's 4 characters in length.

    phpma-createtable-frame08_1

  8. 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

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

    phpma-createtable-frame17_1

  10. When finished, click Save.

    phpma-createtable-frame22_1

  11. That's it! Our new table (details) has been successfully created within our database(demo1234_members) as indicated here.

    phpma-createtable-frame23_1

 

Be Sociable, Share!

    Published by

    Here's 75 % off, Launch a New VPS Today. Find out why 30,000 customers have chosen our Best-in-Class Performance & 24x7 Heroic Support