Skip to content

Instantly share code, notes, and snippets.

@stormwild

stormwild/sql_safe_updates

Last active February 6, 2024 23:52
Show Gist options
  • Star 19 You must be signed in to star a gist
  • Fork 4 You must be signed in to fork a gist
  • Save stormwild/5746860 to your computer and use it in GitHub Desktop.
Save stormwild/5746860 to your computer and use it in GitHub Desktop.
Download ZIP
How to disable MySQL Safe Mode
Raw
sql_safe_updates
UPDATE table_name SET bDeleted=0 WHERE name='xyz';
“You are using safe update mode and you tried to update a table without a WHERE clause that uses a KEY column.”
SET SQL_SAFE_UPDATES=0;
UPDATE table_name SET bDeleted=0 WHERE name='xyz';
SET SQL_SAFE_UPDATES=1;
#http://www.xpertdeveloper.com/2011/10/mysql-safe-update/
@ombhamare4
Copy link

It works Thank You

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment