This article about DELETE in databases is about #Postgres but it generalizes. If you are in CS or into #webdev working with a database in general, it's worth a read.
DELETE is not as easy as people think.
https://notso.boringsql.com/posts/deletes-are-difficult/ #databases