phpMyAdmin Tutorials

Table Creations

phpMyAdmin is intended to handle the administration of MySQL over the web.

Access phpMyAdmin

To access phpMyAdmin, follow the directions listed on the Access phpMyAdmin tutorial. Then continue with the directions below to create a database.

Create Table

In the phpMyAdmin window that appears, click the name of your database in the left pane (just under the icons). Scroll down to 'Create new table on database [database name]' (in this case testdb). In the 'Name' field, enter the name of the table you wish to create (i.e. contacts). In the Fields box, enter the number of fields (columns) for this table (i.e. 3). Click Go.

You should see something like this:

Here you could fill in the details you wish to have.

Note: If unsure about anything, you can leave it blank. This should not be a problem.

The following must be filled:

The 'Field' column should contain the field (column) name for the table.

The 'Type' field should specify the type of content this should be (i.e. an integer (INT), a character (CHAR), Date, etc.)

Note: If unsure of the type, select CHAR as this could be used for all types (not recommended for professional users).

The 'Length/Values' field is used to specify the number of characters allowed to be entered for the 'Field' Column (i.e. 20 characters for a name 'Field' would mean only the first 20 characters are stored in the table).

The rest of the fields are not mandatory. Click Save.