Alejandro Heyworth wrote:
Currently, if I insert integer values into a table with an index ASC (or DESC) on the INT column , a general SELECT will return the values in ascending order.
1 2 3 4 5
That may be true, but only because you haven't been adding and deleting records. It's not something you can depend on, and it has nothing to with the index. If you want a specific order (ascending or descending), you have to specify it in an "ORDER BY" clause.
-- Keith Ivey <[EMAIL PROTECTED]> Washington, DC
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
