如何修复sql错误1064？

rqqzpn5f 于 2021-06-25 发布在 Mysql

关注(0)|答案(1)|浏览(427)

我有一个问题，当我在编辑后导入sql文件时，它会抛出以下错误：

ErrorStatic analysis:2 errors were found during analysis.Unexpected
character. (near "" at position 0)Unexpected beginning of statement. 
(near "" at position 0)SQL query: SET SQL_MODE =
"NO_AUTO_VALUE_ON_ZERO"

mysql说：


# 1064 - You have an error in your SQL syntax;

check the manual that corresponds to your MySQL server version for 
the right syntax to use near ' SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"' at line 1

我该怎么办？

sql mysql mysql-error-1064 syntax-error

来源：https://stackoverflow.com/questions/39907481/how-to-fix-sql-error-1064

1条答案

按热度按时间

q5iwbnjs1#

这样做：

SET @SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
select @SQL_MODE;

赞(0）回复(0）举报 2021-06-25

我来回答

如何修复sql错误1064？

1条答案

相关问题

热门标签

最新问答