ORDER by 'time'

[prudens]

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?

[luca200]

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.

[fenway]

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.