Ravi Sir's Cyber Security Cards › Revision Cards
Safe Update Mode, Error 1175 and Transactions
Safe Update Mode, Error 1175 and Transactions Safe update mode blocks UPDATE or DELETE without a key in WHERE. It shows Error 1175 . A transaction lets you undo changes with ROLLBACK before COMMIT . Many real data-loss cases are one unchecked UPDATE or DELETE. Safe mode, transactions and backups pro
Read card text
What this card says
What it is
Safe update mode blocks UPDATE or DELETE without a key in WHERE. It shows Error 1175.
A transaction lets you undo changes with ROLLBACK before COMMIT.
Why it matters for security
Many real data-loss cases are one unchecked UPDATE or DELETE.
Safe mode, transactions and backups protect your data.
Common mistake
Turning safe mode off forever when you see 1175. The error is MySQL saving you. Fix your WHERE instead.
| Question | Answer |
|---|---|
| What does it block? | UPDATE and DELETE without a WHERE on a key (indexed)… |
| Why is it useful? | Stops accidental full-table changes from a missing or wrong… |
| Where is it on by default? | MySQL Workbench (Edit › Preferences › SQL Editor › "Safe… |
| How to do a planned bulk change? | Use a key in WHERE, or SET SQL_SAFE_UPDATES = 0; for that… |
Learn more in the lesson: 11.2 Safe Update Mode, Error 1175 and Transactions