In the last episode (Aug 19), anders thoresson said:
> Is it possible to resort the rows in a table like in a query where using
> ORDER BY, but have to new sort order stored in the table structure?
CREATE TABLE newtable AS SELECT * FROM oldtable ORDER BY myfield
newtable will have its records physically sorted.
You can also use myisamchk -R on a table to force the records to be
physically sorted by a particular index. This only works on MyISAM
tables.
--
Dan Nelson
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
