← Back to context Comment by marksomnian 8 years ago MySQL Workbench won't let you run an UPDATE or DELETE without a WHERE by default. 3 comments marksomnian Reply h1d 8 years ago Not sure why this isn't default in many tools. That's 99% for hazards. duskwuff 8 years ago Put the following into your ~/.my.cnf to enable it for the command-line client: [client] safe-updates=1 h1d 8 years ago Thanks for the tip, however put that in [mysql] section or otherwise you'll ruin mysqldump command not recognizing that option.
h1d 8 years ago Not sure why this isn't default in many tools. That's 99% for hazards. duskwuff 8 years ago Put the following into your ~/.my.cnf to enable it for the command-line client: [client] safe-updates=1 h1d 8 years ago Thanks for the tip, however put that in [mysql] section or otherwise you'll ruin mysqldump command not recognizing that option.
duskwuff 8 years ago Put the following into your ~/.my.cnf to enable it for the command-line client: [client] safe-updates=1 h1d 8 years ago Thanks for the tip, however put that in [mysql] section or otherwise you'll ruin mysqldump command not recognizing that option.
h1d 8 years ago Thanks for the tip, however put that in [mysql] section or otherwise you'll ruin mysqldump command not recognizing that option.
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:
Thanks for the tip, however put that in [mysql] section or otherwise you'll ruin mysqldump command not recognizing that option.