Home > Database > Mysql Tutorial > body text

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

醉折花枝作酒筹
Release: 2021-06-08 09:24:18
forward
5711 people have browsed it

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.

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

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!

Related labels:
source:csdn.net
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template