07/23: MySQL ＞ Using the --safe-updates Option (or --i-am-a-dummy)
Category: Web dev
Posted by: hajime osako
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
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
