Mysql Single table multi-timestamp Error #1293-Incorrect table definition; there

Mysql returns an error when multiple timestamp entries exist in a single table #1293-Incorrect table definition; there can be only one TIMESTAMP column with C solves the problem of multiple timestamps in a table and setting one of them as current_timestamp. #1293-Incorrect table definition is often encountered; there can be only oneTIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATEclause www.2cto.com because when you set a timestamp to on updatecurrent_timestamp, the default value must be explicitly set for other timestamp fields. However, if you have two timestamp fields The default value is current_timestamp and the second one is not set. mysql can also create tables successfully, but in turn it won't work... www.2cto.com 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.