General UPDATE permissions authorization way:
GRANT UPDATE ON xx. Yyy TO user1 @ server1

But there was a risk the UPDATE permissions, if user1 @ server1 implement operations 1 no WHERE clause, database glasses!
MySQL is there such a permissions: GRANT UPDATE BY KEY ON user1 @ server1, here 'UPDATE BY KEY' said each UPDATE can only be amended BY the primary KEY, namely every time can only modify a record, not a batch or all of the,

CodePudding user response:

Access control should can't, other way should be ok,