Solve the problem of Navicat importing database data structure sql reporting error datetime(0)

Error occurs:

When exporting the database from MySQL 5.7 to SQL and importing it on MySQL 5.5, an SQL statement error is reported: datetime(0)…

Cause of the error

The datetime and timestamp of mysql5.7 and mysql5.5 are incompatible

The format exported by mysql5.7 is: datetime(0), but mysql5.5 cannot recognize this syntax.

Solution

Change datetime(0) in the export statement to datetime, or change timestamp(0) to timestamp

Keep database versions consistent

Supplementary knowledge: Navicat imports sql, and the database data keeps failing to import all the data.

As shown below:

Import interface basic options

Solution:

result:

The above article on solving the problem of sql error datetime(0) when importing database data structure into Navicat is all the content that the editor shares with you. I hope it can give you a reference, and I also hope that you will support 123WORDPRESS.COM.