MySQL uses the "Safe Updates"-Forbid UPDATE and DELETE statements with no key in WHERE clause or no LIMIT clause-checkbox to control the behavior of UPDATE and DELETE statements run from the MySQL Workbench.

Question

Quizplus · Accepted Answer

MySQL Workbench has a "Safe Updates" checkbox that forbids UPDATE and DELETE statements with no key in WHERE clause or no LIMIT clause in order to prevent unintentional deletion or modification of large sets of data.

MySQL Uses the "Safe Updates"-Forbid UPDATE and DELETE Statements with No