anders thoresson unknowingly asked us:
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?
If you use PhpMyAdmin (latest version), follow these steps:
1. Select your table by clicking on the left.
2. Choose '
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 ph
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
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