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 a 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 you want to add a column to
  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.