MySQL AB :: MySQL 5.0 Reference Manual :: 8.8.5.2 Using the --safe-updates Option

What it does is:
SET SQL_SAFE_UPDATES=1,SQL_SELECT_LIMIT=1000, SQL_MAX_JOIN_SIZE=1000000;

How to use:
mysql --safe-updates --select_limit=500 --max_join_size=10000