The MySQL version is lower than the one that does not support two timestamp type values.

The MySQL version is lower than the one that does not support two timestamp type values.

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

The reason is: the MySQL versions of the two servers are inconsistent. The lower version does not support two TIMESTAMP type columns in one table.

The versions in the project are:

  • Configure the environment (recommended jdk8, mysql5.7, maven3, idea)
  • Mine is 5.52

The solution?

The method is to use the latest version on both servers

The above method is very simple. Thank you for your support of 123WORDPRESS.COM.

You may also be interested in:
  • Detailed explanation of TIMESTAMP usage in MySQL
  • FROM_UNIXTIME Format MYSQL timestamp function
  • Functions and methods for converting dates and timestamps in MySQL
  • Detailed explanation of MySQL date string timestamp conversion
  • Two methods to convert mysql timestamp into commonly used readable time format
  • MySQL example of getting today and yesterday's 0:00 timestamp
  • Several ways to add timestamps in MySQL tables
  • Analysis of a murder case caused by MySQL timestamp accuracy

<<:  An example of elegantly writing status labels in Vue background

>>:  Tutorial on installing Odoo14 from source code on Ubuntu 18.04

Recommend

In-depth explanation of the locking mechanism in MySQL

Preface In order to ensure the consistency and in...

Basic operations on invisible columns in MySQL 8.0

Table of contents 01 Create invisible columns 02 ...

Docker executes a command in a container outside the container

Sometimes we want to execute a command in a conta...

How to connect to MySQL remotely through Navicat

Using Navicat directly to connect via IP will rep...

Node.js solves the problem of Chinese garbled characters in client request data

Node.js solves the problem of Chinese garbled cha...

WeChat applet records user movement trajectory

Table of contents Add Configuration json configur...

Solution to the problem of failure to insert emoji expressions into MySQL

Preface I always thought that UTF-8 was a univers...

How to convert mysql bin-log log files to sql files

View mysqlbinlog version mysqlbinlog -V [--versio...

How to configure mysql on ubuntu server and implement remote connection

Server: Ubuntu Server 16.04 LSS Client: Ubuntu 16...

How to use JavaScript and CSS correctly in XHTML documents

In more and more websites, the use of XHTML is rep...

Vue uses vue-quill-editor rich text editor and uploads pictures to the server

Table of contents 1. Preparation 2. Define the gl...

VUE+Canvas realizes the whole process of a simple Gobang game

Preface In terms of layout, Gobang is much simple...

Analysis of the principle of Rabbitmq heartbea heartbeat detection mechanism

Preface When using RabbitMQ, if there is no traff...

Linux configuration without password login stand-alone and full distribution detailed tutorial

Table of contents 1: Single machine password-free...

Vue uses openlayers to load Tiandi Map and Amap

Table of contents 1. World Map 1. Install openlay...