🚤

Om Ghanshyam Bhamare ombhamare4

🚤

I am Computer Science Student studying at St. John college of palghar

stormwild / sql_safe_updates

Last active February 6, 2024 23:52

How to disable MySQL Safe Mode

	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/