I wrote this because maybe the ordering is more expensive than 2 queries (one one
indexed field possibly).
Regards,
Andrey
- Original Message -
From: "Andrey Hristov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, December 21, 2001 5:18 PM
Subject:
Ususally when someone needs to select last row in a table (s)he do:
select * from some_table order by some_field desc limit 1;
but there is another possible solution for mysql :
More info here : http://www.mysql.com/doc/V/a/Variables.html
Regards,
Andrey Hristov
--
PHP General Mailing List
2 matches
Mail list logo
