Creating tables in a database with phpMyAdmin

Posted:  May 14th, 2018

This tutorial assumes you've already logged in to phpMyAdmin. Now let's learn how to create a table within a database.

1) Select your database. In this example, we will use the demo1234_members database.

2) Enter a Name for our new table..

3) Then enter the number of fields this new table is to have. Click Go.

4) Now enter the details of each field within the new table.

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

6) Selecting this option makes the id field the Primary key in the table.

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

8) When finished, click Save.

9) Log out of the server once you are done.