You have an error in your SQL syntax; check the manual that_MySQL
程序员文章站
2022-05-28 18:55:53
...
bitsCN.com
这种错误主要是由于，使用了现在版本的mysql不支持的命令引起的错误，比如
bitsCN.com
从MYSQL5.5开始，TYPE=MYISAM这种类型的命令无法使用，MYSQL已经替换成ENGINE来代替TYPE，如果出现这种错误，批量替换TYPE= 替换成ENGINE=
还有就是timestamp(14) 不能指定长度~这是时间类型~
bitsCN.com
推荐阅读
-
pymysql.err.ProgrammingError: (1064, “You have an error in your SQL syntax； check the manual that co
-
mybatis java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax；
-
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version
-
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version
-
MySql-You have an error in your SQL syntax; check the manual that corresponds to your MySQL server v
-
(1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server
-
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version
-
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version
-
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version
-
Mysql错误：[Err] 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