How can you make UPDATE and DELETE safer?

SQL changing data safely · Freshers

Model answer

Run the same condition in a SELECT first and check the row count, wrap the change in a transaction so you can roll back, take a backup for big changes, and use least-privilege accounts. Some tools can block UPDATE or DELETE without WHERE.

Learn this topic

INSERT, UPDATE and DELETE: Change Data Safely in the course SQL for Beginners: Learn Databases Step by Step.

Sign in to add your own answer.

More questions

• How do you insert, update and delete rows?
• What is the difference between INSERT ... SELECT and INSERT ... VALUES?
• What is an upsert?
• How do you add a column or change a table?
• What are default values and auto-increment/identity columns?
• How do you delete millions of rows safely?