Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

The MySQL version has a lower value solution that does not support two timestamp types.

2025-02-24 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

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. Lower versions do not support columns of type 2 TIMESTAMP in a table.

The versions in the project are:

Configuration environment (recommended jdk8,mysql5.7,maven3, idea) mine is 5.52

The solution?

It adopts the method of using the latest version of both servers.

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report