Latest Content

Fun MySQL fact of the day: the table is a lie

Over the course of the last several weeks, you may have caught me telling partial truths or using "weird" or inconsistent words when talking about MySQL and InnoDB. And now, before we move on to the rest of this week, it's time to clear a few things up. ... read more

Fun MySQL fact of the day: IGNORE at your own peril

Yesterday, we saw how INSERT ... ON DUPLICATE KEY UPDATE can unknowingly result in not-completely-expected situations. To get around that, you may have thought to use INSERT IGNORE, instead. Often, INSERT IGNORE is used when attempting to insert a row that may already exist. The underlying expectation a developer often has ... read more

Fun MySQL fact of the day: ON DUPLICATE KEY LEAK DATA

As developers, part of our job is ensuring system stability long after we are finished writing code. It is our responsibility to ensure the next developer in our place doesn't inherit a system littered with landmines and that our customers' data integrity and privacy is always a top priority ... read more
4 5 6 7 8 9 10