What should I do if there is a problem when MySQL runs a SQL file?

This article will introduce to you the solutions to problems that occur when MySQL runs SQL files. It has certain reference value. Friends in need can refer to it. I hope it will be helpful to everyone.

Reference:

Mysql error: check the manual that corresponds to your MySQL server version for the right syntax [Add ` symbol, modify there Conflicting field names]

check the manual that corresponds to your MySQL server version for the right syntax error [field names use keywords]

check the manual that corresponds to your MySQL server version for the right syntax to use near [an extra comma is added before where]

Mysql exception check the manual that corresponds to your MySQL server version for the right syntax summary [whether sql has Chinese characters, whether it conflicts with keywords, Whether it contains special characters and whether it is separated into lines correctly]

None of the answers in these articles solved my problem! ! !

# Later I use "MySQL workbench workspace8.0" to run the SQL file and encounter errors. , there will be a red underline prompt, and it is found: (There is a problem with the time of the SQL file)

It is not a problem with the insert statement, nor a problem with create, but with the time type. The problem is, whether it is datetime or time, the Navicat premium tool dumps the structure of the data table, and the time will be followed by "(0)"!!!

Change:

Replace all datetime(0) with datetime or time(0) [as shown in the figure, manually modify in xx.sql]:

Related recommendations : "

mysql tutorial"

The above is the detailed content of What should I do if there is a problem when MySQL runs a SQL file?. For more information, please follow other related articles on the PHP Chinese website!