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

Introduction to the functions and usage of value and name attributes in Html

1. The value used in the button refers to the text...

How to change the tomcat port number in Linux

I have several tomcats here. If I use them at the...

In-depth analysis of MySQL lock blocking

In daily maintenance, threads are often blocked, ...

The rel attribute of the HTML link tag

The <link> tag defines the relationship bet...

Detailed explanation of inline elements and block-level elements in commonly used HTML tags

Block element HTML tag classification details * a...

The process of building lamp architecture through docker container

Table of contents 1. Pull the centos image 2. Bui...

Using js to achieve the effect of carousel

Today, let's talk about how to use js to achi...

MySQL uses events to complete scheduled tasks

Events can specify the execution of SQL code once...

Detailed explanation of CSS BEM writing standards

BEM is a component-based approach to web developm...

How to modify the initial password of a user in mysql5.7

When users install MySQL database for the first t...

Centos6.9 installation Mysql5.7.18 step record

Installation sequence rpm -ivh mysql-community-co...

CSS realizes div completely centered without setting height

Require The div under the body is vertically cent...

Detailed explanation of the loading rules of the require method in node.js

Loading rules of require method Prioritize loadin...

Detailed explanation of the loop form item example in Vue

Sometimes we may encounter such a requirement, th...

Detailed steps for setting up host Nginx + Docker WordPress Mysql

environment Linux 3.10.0-693.el7.x86_64 Docker ve...