Grabbing frogs...

Junk in the Trunk


Why is all of our customer data stuck on that tree over there?


I was told to truncate that table.

That is absolutely not what truncate means.


Ah, yes. You've come to the right place!

In reality, truncating a table in SQL means wiping out all the data with no selector. A DELETE statement, unlike TRUNCATE, will have a selector, meaning that it is probably not intended to erase all of the data. I say "probably" and "intended" because who among us hasn't accidentally erased too much data from a production database with a bad SQL statement?

Published Wednesday, 9 March 2022

Vote for us on!
Our Current Rank is: 0