Re: "hard" sort table order

2003-08-19 Thread Rajesh Kumar
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 '

Re: "hard" sort table order

2003-08-19 Thread Dan Nelson
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

Re: "hard" sort table order

2003-08-19 Thread Yves Goergen
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

"hard" sort table order

2003-08-19 Thread anders thoresson
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