Hacker News new | ask | show | jobs
by marksomnian 3305 days ago
MySQL Workbench won't let you run an UPDATE or DELETE without a WHERE by default.
1 comments

Not sure why this isn't default in many tools. That's 99% for hazards.
Put the following into your ~/.my.cnf to enable it for the command-line client:

    [client]
    safe-updates=1
Thanks for the tip, however put that in [mysql] section or otherwise you'll ruin mysqldump command not recognizing that option.