PHP myAdmin - Change Field Order (Move Up Or Down)

Question

How do I change the order of my table fields without deleting the field and re-inserting it, using PHP myAdmin?

Answer 1

Another alternative:

CREATE new_table SELECT columns-in-new-order FROM old_table;

Answer 2

If you have phpMyAdmin 4.0.0+, you can use the phpMyAdmin Feature under Structure:

Answer 3

Something like this will help

ALTER TABLE Person MODIFY COLUMN last_name VARCHAR(50) AFTER first_name;

This will move last_name right after first_name in order.