错误如下:
java.sql.SQLException: 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 '2011-02-09bf(hljid int not null auto_increment,biao_name varchar(30),dengtime1 v' at line 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2921)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1570)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2972)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2902)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:929)
at com.petroleum.jdbc.create_table.create(create_table.java:36)
at com.petroleum.jdbc.create_table.main(create_table.java:49)
java.sql.SQLException: 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 '2011-02-09bf(hljid int not null auto_increment,biao_name varchar(30),dengtime1 v' at line 1我想用JAVA在后台JDBC下直接建立一个新的数据库,语句写好了运行出现这个错误,找高手帮忙解决下!所用数据库MYsql
java.sql.SQLException: 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 '2011-02-09bf(hljid int not null auto_increment,biao_name varchar(30),dengtime1 v' at line 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2921)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1570)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2972)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2902)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:929)
at com.petroleum.jdbc.create_table.create(create_table.java:36)
at com.petroleum.jdbc.create_table.main(create_table.java:49)
java.sql.SQLException: 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 '2011-02-09bf(hljid int not null auto_increment,biao_name varchar(30),dengtime1 v' at line 1我想用JAVA在后台JDBC下直接建立一个新的数据库,语句写好了运行出现这个错误,找高手帮忙解决下!所用数据库MYsql
解决方案 »
- struts1.3 多文件上传 用静态ActionForm 怎么实现
- ehcache jgroup同步问题
- struts1表单数据传递问题
- mysql怎么导出脚本
- 200分请问如何使用java调用document,literal类型的webservices
- 求类似google的搜索功能!
- 简单的jdk1.5配置问题(Eclipse)
- struts1.2.4 缺少文件怎么办?
- JBuilder7Weblogic7整和开发CMP时部署问题???急用!!急用!!在线等待,我大送分!吐!100分
- 请问:我用jbuilder6.0生成ejb为什么说没有javax.ejb.*;
- servlet在初始化的得到request
- 直接执行SQL和在JAVA程序里执行SQL区别在哪?
System.out.println("sql======"+sql);这个是要执行的SQL语句
'-' 作为表的名字是非法的