mysql报错 3000_一次 Mysql 字符集的报错，最后让我万马奔腾！！！

wuba---深圳---龙岗周边---2000-3000元---29---20180121---28657wuba---深圳---龙岗周边---3000-5000元---29---20180121---28658wuba---深圳---龙岗周边---5000-8000元---37---20180121---28659wuba---深圳---龙岗周边---600-1000元---27---20180121---28660wuba---深圳---龙岗周边---600元以下---25---20180121---28661wuba---深圳---龙岗周边---8000元以上---36---20180121---28662Mon Jan22 17:43:14CST 2018Insert Danke check data inserted

java.sql.BatchUpdateException: You have an errorin your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'range,num) values('20180121','wuba','深圳','龙岗周边','8000元以上',36)' at line 1at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2055)

at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1467)

at util.InsertIntoMysql.InsertDankeCheck(InsertIntoMysql.java:224)

at Info.Xx_Danke.Xx_DankeRank(Xx_Danke.java:103)

at Info.Xx_Danke.main(Xx_Danke.java:117)

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an errorin your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'range,num) values('20180121','wuba','深圳','龙岗周边','8000元以上',36)' at line 1at sun.reflect.GeneratedConstructorAccessor2.newInstance(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

at java.lang.reflect.Constructor.newInstance(Constructor.java:526)

at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)

at com.mysql.jdbc.Util.getInstance(Util.java:386)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2825)

at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2156)

at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2459)

at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2007)

...4 more