In article <[EMAIL PROTECTED]>,
"Gabriel B." <[EMAIL PROTECTED]> writes:
> How can i do the following with 4.0?
> delete fom t1 where id in (select id from t1 where usr_id = 10 order
> by date_inserted limit 4,999)
Put the result of the inner SELECT into a temporary table and then use
the multi-
How can i do the following with 4.0?
delete fom t1 where id in (select id from t1 where usr_id = 10 order
by date_inserted limit 4,999)
The ideia is to limit to 4 rows with the same usr_id value before i do
an new insert with that user_id. Ending up with only 5 rows.
I'm trying to not do a sele
