Bug #5752 Restricting Users to a fixed number of update/delete at a time
Submitted: 26 Sep 2004 15:41 Modified: 6 Feb 2006 10:11
Reporter: Santosh Balan Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Server Severity:S4 (Feature request)
Version:4.0 OS:Linux (linux)
Assigned to: CPU Architecture:Any

[26 Sep 2004 15:41] Santosh Balan 
Description:
How about feauture to limit the number of rows updated or deleted in a single query.  

I have users who accidently update the whole table with a wrong "where" clause - when mostly they need to work in a specified set of records not exceeding 40 or 50 rows in the entire table. 

How to repeat:
not applicable

Suggested fix:
some additional feauture to USER_RESOURCE
[6 Feb 2006 10:11] Valeriy Kravchuk 
Thank you for a feature request. Sorry, but I do not think that this kind of limitation can help people who write bad SQL. Anyway, there is LIMIT clause for individual statements (http://dev.mysql.com/doc/refman/5.0/en/delete.html, for example). 

The idea of limiting disk and CPU resources for each individual user (and/or statement) is more useful, but it is known and is not exactly what are you asking about.