Such options might be more appealing to users if it were named something like "--extra-safety" or "--require-where".
Humorless users can use "--safe-updates"
http://dev.mysql.com/doc/refman/5.0/en/mysql-tips.html#safe-...
http://dev.mysql.com/doc/refman/5.0/en/mysql-tips.html#safe-...
More commands could use options to adjust how big guns they let you fire at your feet with...