Creating tables in a database with phpMyAdmin

This tutorial assumes you've already logged in to phpMyAdmin.

Now let's learn how to create a table within a database.

Select your database. In this example, we will use the demo1234_members database.


frame03_1.png

 

Enter a Name for our new table.


frame04_1.png

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

 

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


frame07_1.png

 

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_1.png

 

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


frame13_1.png

 

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


frame17_1.png

 

When finished, click Save.


frame22_1.png

 

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


frame23_1.png

 

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

 

This is article 2 of 12 in the phpMyAdmin series. Please click here for the index.

Have more questions? Submit a request

0 Comments

Article is closed for comments.
Powered by Zendesk