Question

com.mysql.jdbc.exceptions.MySQLSyntaxErrorException:

问题描述：
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 '* from goodclassinfo where goodClassId =0' at line 1

----------------------------------------------------------------------------------------------------------------------------

at java.lang.Thread.run(Thread.java:662)
我的sql代码是：String sqlString = "delete * from goodclassinfo where goodClassId =" + goodClassId ;
String sqlString = "select count(*) from goodinfo where goodClassId=" + goodClassId ;

Answer 1

String sqlString = "delete from goodclassinfo where goodClassId =" + goodClassId ;
删除不用*，
count中间加字段 gooClassId比较好

Answer 2

delete语句 没有* 直接 String sqlString = "delete from goodclassinfo where goodClassId =" + goodClassId ;

Answer 3

提供个思路：
1、将你的程序中的sql先在控制台中打印出来，然后放到mysql的查询分析器中看下是报什么具体错误，能非常容易看到具体的错误，解决方法也就是多或少个字符的事情。
再试下看吧。