我的sql语句那错了

String sql = "insert into new_table valuse(4,'eee',120,19)";

异常:

com.mysql.jdbc.exceptions.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 'valuse(4,'eee',120,19)' at line 1

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

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

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

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

at com.mysql.jdbc.Connection.execSQL(Connection.java:3277)

at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1402)

at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1317)

at DBHelper.JDBCCURD.main(JDBCCURD.java:23)


学无丶直径
浏览 2378回答 1
1回答

Finit

valuse单词写错了,望采纳  values
打开App,查看更多内容
随时随地看视频慕课网APP

相关分类

SQL Server