II. Running SQL Queries on a Database with phpMyAdmin
III. Searching Through a Database with phpMyAdmin
IV. Creating Tables in a Database with phpMyAdmin
V. Deleting Tables from a Database with phpMyAdmin
VI. Importing Databases and Tables with phpMyAdmin
VII. Exporting Databases and Tables with phpMyAdmin
VIII. Renaming Database Tables with phpMyAdmin
IX. Copying a Database Table with phpMyAdmin
X. Inserting Fields into Database Tables with phpMyAdmin
XI. Modifying Fields in Database Tables with phpMyAdmin
XII. Deleting Fields from Database Tables 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 the database here.
- Enter a Name for your 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.
- The first field will be called id, and it will be an integer that's 4 characters in length.
- 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. Selecting this option makes the id field the Primary key in the table.
- 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.