MySQL Performance tuning (i) Select the type of time for the field type

Time Type:

1.5 time types are supported in MySQL, namely date, hour, DATETIME, timestamp, and year.

In the daily build table we want to use the timestamp type first, it has the function of automatic update time, example:

You can also set not to update automatically, only the default value is empty. Such as:

2. Year (2) type is automatically converted to year (4) type

MySQL Performance tuning (i) Select the type of time for the field type