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

Ajax jquery realizes the refresh effect of a div on the page

The original code is this: <div class='con...

Steps to export the fields and related attributes of MySQL tables

Need to export the fields and properties of the t...

Solve the problem of Nginx returning 404 after configuring proxy_pass

Table of contents 1. Troubleshooting and locating...

Introduction to the role of HTML doctype

Document mode has the following two functions: 1. ...

Native JS realizes compound motion of various motions

This article shares with you a compound motion im...

Example of using docker compose to build a consul cluster environment

Basic concepts of consul Server mode and client m...

Three BOM objects in JavaScript

Table of contents 1. Location Object 1. URL 2. Pr...

Introduction to NFS service construction under Centos7

Table of contents 1. Server 2. Client 3. Testing ...

Web page comments cause text overflow in IE

The experimental code is as follows: </head>...

HTML pop-up transparent layer instance size can be set and can be proportional

Copy code The code is as follows: <!DOCTYPE ht...

Solve the problem of docker container exiting immediately after starting

Recently I was looking at how Docker allows conta...

Deployment and configuration of Apache service under Linux

Table of contents 1 The role of Apache 2 Apache I...

Node.js+postman to simulate HTTP server and client interaction

Table of contents 1. Node builds HTTP server 2. H...

How to connect Navicat to the docker database on the server

Start the mysql container in docekr Use command: ...

Setting the engine MyISAM/InnoDB when creating a data table in MySQL

When I configured mysql, I set the default storag...