I just upgraded phpmyadmin and noticed some new options...Under operations, they have the ability to Alter table order by...
What does this do? Anyone know?
Does this change any of the "unique" aspects of fields? Can I cause this to decide in which order by default the table is listed?
If it does, then tweaking in this area can probably cause some optimization for some of us, especially heavily modded boards..
Comments? phpMyAdmin::
Command. Time. Status. SQL query. Kill. 2. system user. None Kill. 66589. mark. localhost. mysql. Query. 0. SHOW PROCESSLIST. Open new phpMyAdmin window
http://www.lsrhs.net/phpMyAdmin/server_processlist.php?lang=en-ut2992f8017a50a76ebf&kill=1HOME |
I don't know what the "ability to Alter table order by..." is referring to but ...
'order by' is part of an SQL command that will order the results of an SQL query. You can order the query by any order of columns used in the query. Thus it does not make any changes to the tables used in the query.
To have the database keep the data within a table ordered then you would use a clustered index on the table.
 Where's The Advantage In Windows Genuine Advantage?
 Stocks Bounce After S&P Joins Bear Market |
New phpmyadmin commands