...

Creating a database table with phpMyAdmin

Creating a database table with phpMyAdmin

This tutorial will show you the steps for creating a database table with phpMyAdmin

Select thedemo1234_members database here
creating a database table with phpMyAdmin

Enter a Name for our new table
creating a database table with phpMyAdmin

Then enter the number of fields this new table is to have. Click Go
creating a database table with phpMyAdmin

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

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
phpMyAdmin Cloud

Selecting this option makes the id field the Primary key in the table
phpMyAdmin Web hosting

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

When finished, click Save
phpMyAdmin Cloud Hosting

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

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

Previous Post
Copy a database table with phpMyAdmin
Next Post
Deleting fields from database tables with phpMyAdmin