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-table delete idiom of 4.0. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
