HomeArchiveAboutThanksGames

Grabbing frogs...

Junk in the Trunk

objectobjectobjectobjectobjectobject

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

objectobjectobjectobject

I was told to truncate that table.

That is absolutely not what truncate means.

objectobjectobjectobject

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

objectobjectobjectobjectobject
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 TopWebComics.com!
Our Current Rank is: 0