Creating Tables in a Database with phpMyAdmin

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

 

Be Sociable, Share!
    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