Web Services

Inserting fields into database tables with phpMyAdmin

This tutorial is going to teach about the program phpMyAdmin, and how to Insert fields into database tables using phpMyAdmin. We will assume that you are already logged into phpMyAdmin. For the purposes of this tutorial, we will be using a database with two tables for our example.

Let's begin by locating the database name in the blue section on the left of the phpMyAdmin screen. Below that is the names of the two tables in our database. Select one of the tables by clicking on it. This will bring up all the details of the table in the white screen on the right hand side.

Below the table with the fields in it, you will see a section that begins with Print view. The next line is Add with a blank box for Fields. Place the number of fields you wish to add in the box. Then you need to choose where to add it. At End of Table, At Beginning of Table, or After with a pull-down menu, showing the fields you already have in your table. You select where you want to place the field by marking the radio button. When you are ready, click on the Go button.

This will take you to a screen where you need to give your new field values and types. For example, if you added an address field, the field would simply be address. The type would be CHAR (or character) and you might want to give it a length of at least 100, so that any length address would fit in the field. When you are done, click on the Save button. That will take you to a screen showing that the table has been altered, and giving the new list of table fields.

Click the Home button, below the phpMyAdmin name. This will return you to the main screen. This is the end of the tutorial. You now know how to add fields in a table using phpMyAdmin.