A director s term ends in a given year, but at no given time of year; depends on the yearly meeting.
I thought I would try YEAR to record it--but, in spite of <a href="http://dev.mysql.com/doc/refman/5.5/en/year.html" title="http://dev.mysql.com/doc/refman/5.5/en/year.html">http://dev.mysql.com/doc/refman/5.5/en/year.html</a> , simply assigning NOW() to such a type does not work. There is also no implicit conversion to DATE. All in all, it behaves as a small integer, not a time type. For my end it is much less good than 'year-00-00', something already slightly obscure.
|Deleting Records in Big tables||11|
|Select clause using from and to (like rownum in Oracle)||1|
|Adding a column to a huge mysql table||2|
|Storage of UTF-8 char in MySQL||2|
|count items in the SET(value1,value2,value3)||2|
|Negative connection/thread IDs in mysqld.log?||1|