Inserting fields into database tables with phpMyAdmin Print

  • 204

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

Let's start by looking for the database name in the blue section on the left of the phpMyAdmin screen. Directly below that is the names of the two tables in our database. Choose one of the tables by clicking on it. This will bring up all the information of the table in the white screen on the right hand side.

Down below the table with the fields in it, you will find a section that starts 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 must 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 choose 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 must give your new field values and types. For example, if you put on an address field, the field would plainly be address. The type would be CHAR or character and you might want to give it a length of at least 100, in order that any length address would fit in the field. Assuming you are finished, click on the Save button. That will bring 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 original screen. This is the end of the article. You already know how to add fields in a table using phpMyAdmin.


Was this answer helpful?

« Back