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.

hope i didnt edit too much @Jarvis. just say the word and i'll undo the proposèd edit. — tony gil, May 12 '16 at 13:55

score 5 · Accepted Answer · edited Jun 20 '20 at 09:12

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.

phpMyAdmin

score 0 · Answer 2 · edited Apr 16 '19 at 12:24

0

If you select all at the bottom of the screen below the table,then click change, you can change them all like you did when first creating the table.

Like so.

edited Apr 16 '19 at 12:24

bummi

27,123
14
62
101

answered Apr 16 '19 at 12:20

Jack Vawdrey

1
1

Can you edit all columns in a table using phpMyAdmin?

2 Answers2

To edit existing columns

To add in new columns