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
