MySQL Notes

Data Types

BIT

Why you should not use BIT columns in MySQL

DATE, DATETIME, and TIMESTAMP

http://www.geeksww.com/tutorials/database_management_systems/mysql/tips_and_tricks/mysql_dateformat_function_and_order_by.php

Convert an Invalid Date to a Valid Equivalent

SELECT '2008-02-31' + INTERVAL 0 DAY;

Returns NULL?

Convert an Invalid Date to the Last Day of that Month

SELECT '2008-02-31' + INTERVAL 0 MONTH;

Returns NULL?