MySQL- Error : 1175 , Safe mode

  Рет қаралды 106

Priyanka Biswas

Priyanka Biswas

Күн бұрын

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.

Пікірлер: 1
@adityachaudhary-ys5yf
@adityachaudhary-ys5yf 7 ай бұрын
it works 😂
MySQL Basics - All about Update
3:47
Priyanka Biswas
Рет қаралды 26
Help Me Celebrate! 😍🙏
00:35
Alan Chikin Chow
Рет қаралды 84 МЛН
Where clause in mysql, how to filter the records from table.
10:31
Data Science Made Easy
Рет қаралды 19
Machining MOST Complicated Part Ever!
8:48
TITANS of CNC MACHINING
Рет қаралды 6 М.
If Your Tech Job is Comfortable, You're in Danger
20:57
Thriving Technologist
Рет қаралды 14 М.
Why We Can't Detect AI-Generated Content and How DeepFakes Work
16:25
Harper Carroll AI
Рет қаралды 214