I made a table in my local PHPMyAdmin. I can do all sorts of things with it, but I cannot make even the slightest alteration. For example, under the tab Operations, there is the function Alter Table Order By. But even that it won't do. I can select a field, select Ascending or Descending, click Go, and the system will even report back that the query has been executed successfully. But when I subsequently browse the table, nothing has changed. No matter which field I select.
The alternative method doesn't work either. It will let me hustle the table all I want, as long as it goes via the command
SELECT * FROM `table_name` ORDER BY `field_name` .
But when I enter
ALTER TABLE `table_name` ORDER BY `field_name`
the table doesn't change one iota, while I do get the message that the query has been executed successfully.
What's up with that??
----------------------------------------------------
Edit: I got an answer already, via Stackoverflow.com. See here for the answer: http://stackoverflow.com/questions/1654 ... -my-tables. This behavior is standard as of MySQL 5.5, but XAMPP/PHPMyAdmin seemingly has not been updated yet in that respect.