Creating Database Tables with phpMyAdmin

This tutorial assumes you’ve already logged in to phpMyAdmin:

1. Select the demo1234_members database here

2. Enter a Name for the new table

3. Enter the Number of Fields this new table is to have. Click Go

Create Database Table - phpMyAdmin - New Table

4.  Enter the Field details within the new table

5. The first field is called ID, and it will be an integer that’s 4 characters in length. This is the Primary Key that will be automatically filled in (auto_increment) when new entries are added to the table

Create Database Table - phpMyAdmin - First Field is ID

6. Selecting this option makes the ID field the Primary key in the table

Create Database Table - phpMyAdmin - Set Primary Key

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

8. Click Save when done

Create Database Table - phpMyAdmin - Character Fields

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

Create Database Table - phpMyAdmin - Table Details Created

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

What Our Customers say...