A Web.com Partner

Create a database table in phpMyAdmin

This tutorial will show you how to create a database table in phpMyAdmin

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

Select thedemo1234_members database here

frame03_158

Enter a Name for our new table

frame04_165

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

frame05_159

Now enter the details of each field within the new table

frame07_158

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 that’s 4 characters in length

frame08_150

Selecting this option makes the id field the Primary key in the table

frame13_137

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

frame17_127

When finished, click Save

frame22_116

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

frame23_116

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

x
Chat