search

gvwilson / sql-tutorial

The Querynomicon: An Introduction to SQL for Wary Data Scientists
https://gvwilson.github.io/sql-tutorial/
Other
419 stars 35 forks source link

feat: apply condition to update and delete #7

Closed gvwilson closed 5 months ago

gvwilson commented 5 months ago

For Update and Delete records, advise them to use a select with the condition they will apply with the update or delete to check they are reaching the correct set of rows. It is like testing your update and deleting it before applying it.

— @yabellini