Safe UPDATE and DELETE Practices

Avoiding Accidents

Safe Update Mode

SET SQL_SAFE_UPDATES = 1;
-- now this is BLOCKED (no WHERE with a key):
DELETE FROM students;   -- Error 1175

-- allowed (uses key column):
DELETE FROM students WHERE roll_no = 5;

Safe Habits

• Run a SELECT with the same WHERE first to preview affected rows.
• Wrap risky changes in a transaction so you can ROLLBACK.

Summary

• SQL_SAFE_UPDATES blocks UPDATE/DELETE without a key-based WHERE.
• Preview with SELECT and use transactions to stay safe.

Accidents से बचना

Safe Update Mode

SET SQL_SAFE_UPDATES = 1;
-- अब यह BLOCKED है (key के साथ WHERE नहीं):
DELETE FROM students;   -- Error 1175

-- allowed (key column use करता है):
DELETE FROM students WHERE roll_no = 5;

Safe आदतें

• पहले उसी WHERE के साथ SELECT चलाकर affected rows देखें।
• Risky changes को transaction में रखें ताकि ROLLBACK कर सकें।

सारांश

• SQL_SAFE_UPDATES key-based WHERE बिना UPDATE/DELETE रोकता है।
• SELECT से preview करें और transactions use करें।