Can you edit all columns in a table using phpMyAdmin?

Question

Using phpMyAdmin: can one alter a table's schema by inserting new columns, as one would using spreadsheet software? Like when one creates a new table.

Answer 1

If you click the Structure tab you'll be able to affect the columns or add in new ones.

To edit existing columns

• Check the box on the left of the columns
• Click the pencil icon below the structure display.

The next screen will allow you to adjust the column properties of those selected.

To add in new columns

Look below the table structure display

• Enter however many new columns, and where in the table they'll go
• Click Go.

The next screen will allow you to enter the properties for each of the new columns for the table.