Shulou(Shulou.com)05/31 Report--

This article mainly introduces MySQL running SQL file when the problem solution, has a certain reference value, interested friends can refer to, I hope you read this article after a lot of gains, the following let Xiaobian with everyone to understand.

Reference:

MySQL Error:check the manual that corresponds to your MySQL server version for the right syntax

check the manual that corresponds to your MySQL server version for the right syntax

check the manual that corresponds to your MySQL server version for the right syntax to use near

Mysql exception check the manual that corresponds to your MySQL server version for the right syntax Summary [sql whether there are Chinese characters, whether it conflicts with keywords, whether it contains special characters, whether it branches correctly]

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

Later I use "MySQL workbench workspace8.0" to run SQL files. If I encounter errors, there will be red underscores. I found: (There is a problem with the time of SQL files)

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

Change:

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

Thank you for reading this article carefully. I hope that Xiaobian's "MySQL running SQL file when the problem occurs" this article is helpful to everyone. At the same time, I hope that everyone will support it a lot. Pay attention to the industry information channel. More relevant knowledge is waiting for you to learn!

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.