move field up/down in a table using phpmyadmin?

Question

is there a way to move an existing entry up/down in a table?

i cant see any button for it in phpmyadmin.

Answer 1

You can move field up down easily with syntax like this.

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