John, >I have a table with 1600 student locks in random order. I would like them permanently sorted by the locker number they are >assigned to. I assumed that ... > >~ I would copy the table under a different name >~ Delete all records from this copy >~ Write a statement that would copy the records from the original table into the copied table in SORTED order >~ Delete the original table >~ Rename the copy to the same name as the original > >Question 1: Is there a better way to get the desired result? >Question 2: If not, what would the Insert/Select statement look like that would copy the records over in sorted order?
Tables aren't sorted. Period. Only result-sets can be sorted. Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle & MS SQL Server Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
