Bug #14718 Support offset to DELETE with LIMIT
Submitted: 7 Nov 2005 19:15 Modified: 17 Dec 2010 7:47
Reporter: Gbz Bugzilla Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: DML Severity:S4 (Feature request)
Version:5.0 OS:Linux (Linux)
Assigned to: CPU Architecture:Any

[7 Nov 2005 19:15] Gbz Bugzilla
There seems to be no convenient way to delete all minus n rows.

How to repeat:
Well, prove me wrong.

Suggested fix:
If the DELETE command would accept 2 values for LIMIT (as SELECT does), then this syntax would be able to do the job:
DELETE FROM table ORDER BY date_column DESC LIMIT 10,1000 }

By the way, why don't you add a specific syntax for "unlimited number of rows", like LIMIT 95,0 or LIMIT 95,*
instead of requiring a large number like LIMIT 95,18446744073709551615 which is rather silly.
[30 Oct 2009 13:15] Lukas Smith
[19 Nov 2010 9:50] Sebastian Haaf
[13 Jan 2012 20:09] Mark Rose
[21 Nov 2018 21:52] Maneetta Antony
any update on this?