Take the 2-minute tour ×

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

i cant see any button for it in phpmyadmin.

share|improve this question
add comment

2 Answers

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

ALTER TABLE `table_name` MODIFY `column_you_want_to_move` DATATYPE AFTER `column`
share|improve this answer
can we do it using graphical interface? –  Naeem Jan 23 at 11:05
add comment

If your table doesn't contain any data yet you can simply rename the columns in this case. However; It's not necessary, it really doesn't matter that much in which order the columns are.

share|improve this answer
add comment

Your Answer


