MySQL single table multiple timestamp error #1293-incorrect table definition; There can is only one TIMESTAMP column with Current_timestamp in DEFAULT or on UPDATE clause

When multiple timestamp are present in a table and one is set to Current_timestamp, you often encounter
#1293-incorrect table definition; There can is only onetimestamp column with Current_timestamp in DEFAULT or on Updateclause

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

But if you have two timestamp fields, but only the first one is set to Current_timestamp and the second does not have a default value, MySQL can build the table successfully, but not in the reverse ...

N.B: The red explanation is online, in fact on Updatecurrent_timestamp (in the Navicat Chinese version for the "Refresh current timestamp timing" option) can only set one, or do not set can be set at the same time 2 or more.

Solutions

Change the second type after you run out of SQL statements.

MySQL single table multiple timestamp error #1293-incorrect table definition; There can is only one TIMESTAMP column with Current_timestamp in DEFAULT or on UPDATE clause