The MySQL version is low and does not support the value solution of two timestamp types

  • 2021-12-12 06:05:22
  • OfStack

MySQL error: Error code: 1293 Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP

The reason is that the mysql versions of the two servers are not the same. The lower version does not support two TIMESTAMP type columns in one table.

The version in the project is:

Configuration environment (recommended jdk8, mysql5.7, maven3, ideas) Mine is 5.52

Solution?

Is to use the latest version of both servers

The above method is very simple, thank you for your support of this site.


Related articles: