phpMyAdmin: Creating tables in a database
This tutorial assumes you’ve already logged in to phpMyAdmin
Now let’s learn how to create a table within a database
Select the database here
Enter a Name for our new table
Then enter the number of fields this new table is to have. Click Go
Now enter the details of each field within the new table
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
Selecting this option makes the id field the Primary key in the table. You can also enable auto increment by checking the A_I check box.
The remaining fields will be CHAR (character) fields. Be sure the length is set long enough to accommodate the fields
When finished, click Save
That’s it! Our new table (details) has been successfully created within our database.
This is the end of the tutorial. You now know how to create new tables within a database using phpMyAdmin