Greetings, How do I get the rows in a table to be in a different order? I know I can sort a SELECT statement with an ORDER BY clause, but how do I make this a permanent adjustment to the table, so that all future SELECTs will produce ordered data? How does MySQL know what orders the rows are in (how are they actually stored), and how can I change that?
Here's what's happening: say I have a table with an ID field like this: ID -- 1 2 3 4 5 Then I delete a few rows: ID -- 1 2 5 Now, if I insert new rows, they come out like this: ID -- 1 2 7 6 5 How do I get the table so that the inherent order of the rows (not just the output of a SELECT query with an ORDER BY) is numerical? -b ===== --------------------------------------------------------------------------- Schrodinger may have slept here. --------------------------------------------------------------------------- __________________________________________________ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php