mysql optimization - how to prevent full table updates in mysql

Question

MySQL has a safe mode, but sometimes in business, we need to update multiple rows of records, but we want to prevent all table fields from being updated.
I saw on the Internet that there is a way to prevent the entire table from being updated through triggers. How should I write it?

Answer 1

I don’t quite understand the question. What do you mean by safe mode? Do you mean that only updates with where conditions are allowed after sql_safe_updates is turned on? If this is turned on, it will be enough to prevent misoperations from updating the relevant fields of the entire table. . Also, does preventing all table fields from being updated prevent multiple rows of records you want to update, or what?