Inserting fields into database tables with phpMyAdmin

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.

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Managing MySQL Databases With PHPMyAdmin

On the main cPanel page, scroll down to the section called Databases, and click on the icon named...

How To Create A MySQL Database

On the main cPanel page, scroll down to the Database section, and click on the MySQL Databases...

Importing databases and tables with phpMyAdmin

The phpMyAdmin main screen is broken into two sections. The left hand side is blue, and this is...

Deleting tables in a database with phpMyAdmin

For this tutorial, we will be using a database with two tables for the example. In the left hand...

Exporting databases and tables with phpMyAdmin

The phpMyAdmin main screen is broken into two sections. The left hand side is blue, and this is...

Powered by WHMCompleteSolution