3 ms·

MySQL Workbench won't let you run an UPDATE or DELETE without a WHERE by default.

• h1d 9y ago
  Not sure why this isn't default in many tools. That's 99% for hazards.
  • duskwuff 9y ago
    Put the following into your ~/.my.cnf to enable it for the command-line client: [client] safe-updates=1
    • h1d 9y ago
      Thanks for the tip, however put that in [mysql] section or otherwise you'll ruin mysqldump command not recognizing that option.