1. Home
  2. How to insert fields into database tables with phpMyAdmin?
  1. Home
  2. How to insert fields into database tables with phpMyAdmin?

How to insert fields into database tables with 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 navbar
  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 line
  6. Select the location of the new column
  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 April 13, 2020

Was this article helpful?