"Lorderon" <[EMAIL PROTECTED]> wrote:
> Mabye, is there a way to tell MySQL to limit the temporary table up to 500
> rows? so, when a row is matching into the top 500 rows, the last row will be
> dropped out (in case the table is on limit), and the new matched row will be
> inserted into the right
Hi All,
There's something that bothers me..
I have a query that uses a temporary table (has a necessary GROUP BY
clause). The query also uses ORDER BY clause (necessary too). And I also use
LIMIT clause.
If the query finds 10,000 rows, then MySQL will insert 10,000 rows into the
temporary table an
