对于想了解mysql删除表加别名报错[Err]1064-YouhaveanerrorinyourSQLsyntax;checkthemanualthat.....的读者，本文将提供新的信息，并且为您提

对于想了解mysql 删除表加别名 报错 [Err] 1064 - You have an error in your SQL syntax; check the manual that .....的读者，本文将提供新的信息，并且为您提供关于1064 - syntax error, error in :''Id`) USING BTREE、Caused by: java.sql.BatchUpdateException: You have an error in your SQL syntax; check the manual tha、check the manual that corresponds to your MySQL server version for the right syntax to use near、check the manual that corresponds to your MySQL server version for the right syntax to use near ''lim的有价值信息。

本文目录一览：

• mysql 删除表加别名 报错 [Err] 1064 - You have an error in your SQL syntax; check the manual that .....
• 1064 - syntax error, error in :''Id`) USING BTREE
• Caused by: java.sql.BatchUpdateException: You have an error in your SQL syntax; check the manual tha
• check the manual that corresponds to your MySQL server version for the right syntax to use near
• check the manual that corresponds to your MySQL server version for the right syntax to use near ''lim

mysql 删除表加别名 报错 [Err] 1064 - You have an error in your SQL syntax; check the manual that .....

delete from table_name a where a.id = 42830949280530432

报错

[SQL]delete from table_name a where a.id = 42830949280530432

[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 near ''a where a.id = 42830949280530432'' at line 1

 

需要

delete a from table_name a where a.id = 42830949280530432

运行正常

[SQL]delete a from table_name a where a.id = 42830949280530432

受影响的行: 1
时间: 0.074s

正常不加别名  

delete  from iom_pmv_performance where id = 42830949280530432

也是运行正常

1064 - syntax error, error in :''Id`) USING BTREE

mycat 执行如下脚本报错 ：1064 - syntax error, error in :''Id`) USING BTREE

DROP TABLE IF EXISTS `score`;
CREATE TABLE `score` (
`Id` int(11) NOT NULL AUTO_INCREMENT,
`Name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
`grade` int(11) NULL DEFAULT NULL,
`Remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
PRIMARY KEY (`Id`)  USING BTREE,
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Compact;

 

解决方法，将最后两句更改为

DROP TABLE IF EXISTS `score`;
CREATE TABLE `score` (
`Id` int(11) NOT NULL AUTO_INCREMENT,
`Name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
`grade` int(11) NULL DEFAULT NULL,
`Remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
PRIMARY KEY (`Id`),
KEY `Id` USING BTREE(`Id`)
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Compact;

Caused by: java.sql.BatchUpdateException: You have an error in your SQL syntax; check the manual tha

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

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 ''(97168,26195,661,4.708181029,''prefer''),(97168,26195,740,7.4143620581,''prefer''),('' at line 1
    at sun.reflect.GeneratedConstructorAccessor8.newInstance(Unknown Source)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
    at com.mysql.jdbc.Util.getInstance(Util.java:408)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3970)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3906)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2677)
 

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

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 ''limit 1, 6'' at line 1
	sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
	sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	java.lang.reflect.Constructor.newInstance(Constructor.java:423)
	com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
	com.mysql.jdbc.Util.getInstance(Util.java:381)

sql写的有问题，在sql结尾多写了一个“；”，建议遇到类似问题，先仔细检查一下sql 的正确性；

我们今天的关于mysql 删除表加别名 报错 [Err] 1064 - You have an error in your SQL syntax; check the manual that .....的分享已经告一段落，感谢您的关注，如果您想了解更多关于1064 - syntax error, error in :''Id`) USING BTREE、Caused by: java.sql.BatchUpdateException: You have an error in your SQL syntax; check the manual tha、check the manual that corresponds to your MySQL server version for the right syntax to use near、check the manual that corresponds to your MySQL server version for the right syntax to use near ''lim的相关信息，请在本站查询。

本文标签：

• MySQL
• 删除表
• 别名报错
• SQL语法错误