• TIMESTAMP vs. DATETIME, which should I be using?

    May 22, 2011

    They both look the same, have roughly the same use. Nevertheless, they differ in many respects. I'll note the difference, and note a few pitfalls and peculiarities. Range TIMESTAMP starts with the epoch, '1970-01-01 00:00:01' UTC and ends with '2038-01-19 03:14:07' UTC. This is all very nice today, and may actually hold up till our […]

  • Tales of the trade #5: How to author a super successful MySQL blog

    May 18, 2011

    Check out the following tutorial that teaches you how to become a popular MySQL blog author: Complete strip: tales-of-the-trade-make-your-mysql-blog-popular-full.png

  • Problems with MMM for MySQL

    May 16, 2011

    I recently encountered troubling issues with MMM for MySQL deployments, leading me to the decision to cease using it on production. At the very same day I started writing about it, Baron published What's wrong with MMM?. I wish to present the problems I encountered and the reasons I find MMM is flawed. In a […]

  • Pop quiz answered: "what would be the results of the following queries?"

    May 12, 2011

    The quiz presented poses with an uncommon, though valid SQL syntax: one is allowed to use quoted name aliases. Thus, it is valid to write: SELECT Name AS 'n', Continent AS 'c' FROM countries But what does the above mean? Let's see the results of our three questions:

  • Pop quiz: what would be the results of the following queries?

    May 12, 2011

    Here's a quiz for you. The real query I witnessed was very complicated. I've simplified it, but kept a confusing alias. Can you answer the following three questions? Are they even valid? Given the following countries table data:

 
Powered by Wordpress and MySQL. Theme by openark.org