MySQL datetime Update, delete some old concepts on the Web

The old concept of the Internet

1th: The minimum value for the datetime of the previous MySQL is: ' 1000-01-01 00:00:00 ' (seemingly), but the latest MySQL test datetime minimum value can be: ' 0000-00-00 00:00:00 ' (0000-00-01 00:00:00 can also be inserted),

But I'm using ' 0001-01-01 00:00:00 ' as the minimum value (typically used instead of a null value as the default value for that column) because the datetime minimum value for C # is the value.

2nd: previously only TIMESTAMP types can be set to a default value of Current_timestamp, and only one TIMESTAMP column can be in a table.

But the newest MySQL, the datetime type can also set the default value is current_timestamp used to record the creation time of the row in the data table, and can add another column is a datetime type and the default value

The current_timestamp on update current_timestamp is used to record the updated time of rows in the data table, which are best set to NOT NULL.

MySQL datetime Update, delete some old concepts on the Web