#100DaysOfCode - Day 13: SQL DELETE
Today, I got to work a bit in SQL, and learn how to
output elements of a table after they’re being deleted.
In Day 7 and Day 8, we talked about the
DELETE statement, which does an action on some rows of a table. Very useful commands!
Well, to expand on those commands, you may want to output the data you’re deleting, as a sort of sanity check to make sure that you only deleted what was expected. Well, how would you do that?
Turns out, it’s pretty simple:
DELETE * OUTPUT DELETED.* FROM A WHERE A.ID = 1
This can be done with
UPDATED) statements as well! The trick is just to make sure you have the
OUTPUT clause right before the
FROM <table> clause =)