joaca Posted March 16, 2009 Share Posted March 16, 2009 Hey, how do you sort data within a mysql table without retrieving the data using SELECT statement. Say updating data to be in ascending order without selecting Quote Link to comment Share on other sites More sharing options...
Zane Posted March 16, 2009 Share Posted March 16, 2009 say what? If you aren't going to select it then why does it matter if it's ascending or descending... Apparently you want to sort something that no one will ever noticed is sorted.... ..correct? Quote Link to comment Share on other sites More sharing options...
Mchl Posted March 16, 2009 Share Posted March 16, 2009 In other words, the answer is: you don't. Quote Link to comment Share on other sites More sharing options...
fenway Posted March 16, 2009 Share Posted March 16, 2009 In other words, the answer is: you don't. You could, though, with ALTER TABLE, say for a table that isn't being updated anymore (e.g. ARCHIVE). Quote Link to comment Share on other sites More sharing options...
Mchl Posted March 16, 2009 Share Posted March 16, 2009 Indeed, I guess it could make sense for archival data, that is selected always (or mostly) in same order. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.