MySQL Build table timestamp error

When MySQL builds a table with two or more fields timestamp, the following error may occur:

Incorrect table definition; There can is only one TIMESTAMP column with Current_timestamp in DEFAULT or on UPDATE

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 ...

MySQL Build table timestamp error