ALTER TABLE table ORDER BY col --from the manual-- ORDER BY allows you to create the new table with the rows in a specific order. Note that the table will not remain in this order after inserts and deletes. In some cases, it may make sorting easier for MySQL if the table is in order by the column that you wish to order it by later. This option is mainly useful when you know that you are mostly going to query the rows in a certain order; by using this option after big changes to the table, you may be able to get higher performance.
-- Yves Goergen [EMAIL PROTECTED] Please don't CC me (causes double mails) -----Ursprüngliche Nachricht----- Von: "anders thoresson" <[EMAIL PROTECTED]> An: <[EMAIL PROTECTED]> Gesendet: Dienstag, 19. August 2003 22:06 Betreff: "hard" sort table order > 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? > > -- > anders thoresson > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
