1. Home
  2. Third-Party Integration
  3. phpMyAdmin
  4. Adding a Column to an Existing Table in phpMyAdmin

Adding a Column to an Existing Table in phpMyAdmin

Adding a column to a table is a necessary step in creating a functioning database in phpMyAdmin. If you need to set up a database, see our article, Create a Database. To see how to add columns to a database, follow the instructions below:

Adding a Column to an Already Existing Database Table in phpMyAdmin  

  1. Log in to phpMyAdmin. For help doing this, see our article, Accessing phpMyAdmin in the ACC
  2. Once logged in, go to the left sidebar and click the name of the database table you want to add a column to

    If you do not have any tables created, you will need to first create a table. Columns can easily be added in the new table interface.

  3. Click Structure in the top navbarImage of structure button
  4. Underneath your existing columns, there is a line: Add # Columns
  5. Enter the number of columns you want to add in the number field in this lineimage of number field
  6. Select the location of the new columnImage of location selection
  7. Click Go

This will take you to a new page where you can enter the details of the new column. When you have finished editing your column, click Save.

Image of details editor

This will add your column to your table.

Updated on July 6, 2018

Was this article helpful?

Related Articles