Data Integrity

Data
Databases
MySQL
Next BaseLine

The curse of MySQL warnings

Ronald Bradford
June 10, 2024

MySQL warnings are an anti-pattern when it comes to maintaining data integrity. When the information retrieved from a database does not match what was entered, and this is not identified immediately, this can be permanently lost.

Databases MySQL Uncategorized

Why SQL_MODE is essential even when not perfect

Ronald Bradford
February 16, 2012

In a recent rant on Why I think SQL_MODE is useless… , I wanted to counteract this statement with why we MUST all use SQL_MODE, even with the inherit flaws.

Databases Kaleidoscope 2010 MySQL Oracle/MySQL Conferences

MySQL Idiosyncrasies That Bite

Ronald Bradford
June 28, 2010

The following are my slides that I presented at ODTUG Kaleidoscope 2010 . This presentation talks about the MySQL defaults including a non-transactional state, silent data truncations, date management, and transaction isolation options.