Hi all, I have a table like that
table1: field1 field2 . . . where : field1,field2 is the primary key. When I make this query: SELECT * FROM table1 USE INDEX(PRIMARY) I get a different result, if I make this: SELECT * FROM table1 ORDER BY field1,field2 Why? Is not the same? What is the default order, that MySQL use if for this table, I make : SELECT * FROM table1 thanks in advance Javier Diaz IT Developer - Scanned for all known viruses by Messagelabs -- --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php