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 […]
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
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 […]
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:
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: