Creating tables in a database with phpMyAdmin
Knowledgebase Article
Creating tables in a database with phpMyAdmin
Now let's learn how to create a table within a database
Select thedemo1234_members 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 that's 4 characters in length
The remaining fields will be CHAR (character) fields. Be sure the length is set long enough to accomodate the fields
When finished, click Save
That's it! Our new table (details) has been successfully created within our database(demo1234_members) as indicated here
This is the end of the tutorial. You now know how to create new tables within a database using phpMyAdmin
Related Articles
-
Becoming familiar with databases in phpMyAdmin
-
Creating tables in a database with phpMyAdmin
-
Deleting tables from a database with phpMyAdmin
-
Inserting fields into database tables with phpMyAdmin
-
Modifying fields in database tables with phpMyAdmin
-
Deleting fields from database tables with phpMyAdmin
-
Exporting databases and tables with phpMyAdmin
-
Importing databases and tables with phpMyAdmin
-
Running SQL queries on a database with phpMyAdmin
-
Renaming database tables with phpMyAdmin
-
Searching through a database with phpMyAdmin
-
Copying a database table with phpMyAdmin
-
How to create a MySQL database in cPanel
-
How to access MySQL remotely
Powered by WHMCompleteSolution