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