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

ALTER TABLE `table_name` MODIFY `column_you_want_to_move` DATATYPE AFTER `column`

DATATYPE is something like DATETIME or VARCHAR(20) ..etc


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


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.