prudens Posted June 5, 2008 Share Posted June 5, 2008 Hi, Is there anyway to manually set in mySQL to rank my table by ORDER of 'time'? I hate to call the "ORDER BY" in query all the time... anyway to set it as a default option in phpMyAdmin? Quote Link to comment https://forums.phpfreaks.com/topic/108788-order-by-time/ Share on other sites More sharing options...
luca200 Posted June 5, 2008 Share Posted June 5, 2008 You can create a new database theory on your own. In RDBMS, there isn't any given order in table rows, so if you want some you MUST use ORDER BY. Quote Link to comment https://forums.phpfreaks.com/topic/108788-order-by-time/#findComment-558142 Share on other sites More sharing options...
fenway Posted June 5, 2008 Share Posted June 5, 2008 You can create a new database theory on your own. In RDBMS, there isn't any given order in table rows, so if you want some you MUST use ORDER BY. Not entirely true... you can issue an ALTER statement with an ORDER BY clause, and then you don't need to use it explicitly -- but this is only helpful if the table doesn't change w.r.t this field. Quote Link to comment https://forums.phpfreaks.com/topic/108788-order-by-time/#findComment-558316 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.