Рет қаралды 106
Sharing MySQL Basics.
While working query update and set, came across the error : 1175 -
Update cats set age=14 where name="misty" Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column. To disable safe mode, toggle the option in Preferences .
Accessed Preferences, but i did not find anything or may be did not understand anything.
after seacrhing found and checked this - SET SQL_SAFE_UPDATES = 0;
and this worked.
Hope it helps people who are non coders.
Let me know if anyone finds this helpful and if you want more videos on basics of SQL.