java 报错com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column ‘男子3000米‘ in ‘where

报错com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column ‘男子3000米‘ in ‘where"/>

java 报错com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column ‘男子3000米‘ in ‘where

Java报错

报错语句

String sql="delete from ident where sport_even="+sport_even+" ";

解决办法

有时候sql语句需要在变量后面加上’ '(单引号),加上单引号就好了。

String sql="delete from ident where sport_even= '"+sport_even+"' ";