is there a way to move an existing entry up/down in a table?
i cant see any button for it in phpmyadmin.
+1
A:
Um... Why? Tables don't need to be in order. phpMyAdmin just pulls them alphabetically. Theres no way to do it. Unless you make it yourself...
AjayP
2010-04-12 01:35:14
oh sorry, i meant a field, not a entry.
never_had_a_name
2010-04-12 04:06:02
Entries are in order of the key you set such as an ID column. In a SQL Query you may use the ORDER BY clause to sort it, in phpmyadmin, click on the column name you wish to sort by and it will do so.
AjayP
2010-04-12 04:09:27
i think u're misunderstanding. when i create a table i specify the fields (columns) and they will have the order i specify them in. so first "name", "lastname", "firstname", "email". But then i discover that i want firstname to come before lastname and i want to move that column. how do i do that?
never_had_a_name
2010-04-12 06:42:00
A:
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.
Lex
2010-04-13 09:28:13