What Data Type is Returned by a Mathematical Function?
Or, “Missing information in the MySQL Manual”. Just earlier today, I was using POW(), which I’ve...
Pythian Blog: Data Analytics, Cloud Computing, and Database Management | Nicklas Westerlund
mysqlbinlog Tips and Tricks
So, you have a binlog. You want to find out something specific that happened inside of it. What to...
Adding a Unique Constraint on a Table with Duplicate Data
After I moved back to Europe and Malta in order to set up our operations here, I was approached by...
MySQL Back to Basics: Analyze, Check, Optimize, and Repair
It felt like the right time for us to look back at some useful commands for table maintenance that...
