Multiple timestamp errors in a single mysql table #1293

Mysql returns an error when multiple timestamp entries exist in a single table #1293 bitsCN.com

Mysql single table multiple timestamp error #1293-Incorrect table definition; there can be only one TIMESTAMP column with C solution

When multiple timestamps are displayed in a table and one of them is set to current_timestamp

#1293-Incorrect table definition; there can be only oneTIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATEclause

The reason is that when you set a timestamp to on updatecurrent_timestamp, other timestamp fields need to explicitly set the default value.

However, if you have two timestamp fields, but only set the first one to current_timestamp, and the second to do not set the default value, mysql can also successfully create a table, but in turn it won't work...

N. b: The above explanation is online. In fact, on updatecurrent_timestamp (the "refresh current timestamp" option in the Chinese version of navicat) can only be set to one or not set, you cannot set two or more.

BitsCN.com