关于You have an error in your SQL syntax; check the manual that corresponds..的解决

代码如下:

pstmt = conn.prepareStatement("insert into column(columnTitle) values(?)");
pstmt.setString(1, column.getColumnTitle());

执行这个插入语句的时候,出现以下错误信息:
[quote]
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 'column(columnTitle) values('?¨±????…????')' at line 1
[/quote]
一直把问题定位为插入语句的语法有问题,查找的时候也是往这个方向查,以至于对于网上说的”关键字引用错误”之类的解决方法直接无视, :cry: 后来终于看到有个同学跟我用了同样一个关键字“column”作为表名,问题解决,呃~为了防止再犯这样的错误,贴上mysql关键字列表:
[table]
|ADD|ALL|ALTER|
|ANALYZE|AND|AS|
|ASC|ASENSITIVE|BEFORE|
|BETWEEN|BIGINT|BINARY|
|BLOB|BOTH|BY|
|CALL|CASCADE|CASE|
|CHANGE|CHAR|CHARACTER|
|CHECK|COLLATE|COLUMN|
|CONDITION|CONNECTION|CONSTRAINT|
|CONTINUE|CONVERT|CREATE|
|CROSS|CURRENT_DATE|CURRENT_TIME|
|CURRENT_TIMESTAMP|CURRENT_USER|CURSOR|
|DATABASE|DATABASES|DAY_HOUR|
|DAY_MICROSECOND|DAY_MINUTE|DAY_SECOND|
|DEC|DECIMAL|DECLARE|
|DEFAULT|DELAYED|DELETE|
|DESC|DESCRIBE|DETERMINISTIC|
|DISTINCT|DISTINCTROW|DIV|
|DOUBLE|DROP|DUAL|
|EACH|ELSE|ELSEIF|
|ENCLOSED|ESCAPED|EXISTS|
|EXIT|EXPLAIN|FALSE|
|FETCH|FLOAT|FLOAT4|
|FLOAT8|FOR|FORCE|
|FOREIGN|FROM|FULLTEXT|
|GOTO|GRANT|GROUP|
|HAVING|HIGH_PRIORITY|HOUR_MICROSECOND|
|HOUR_MINUTE|HOUR_SECOND|IF|
|IGNORE|IN|INDEX|
|INFILE|INNER|INOUT|
|INSENSITIVE|INSERT|INT|
|INT1|INT2|INT3|
|INT4|INT8|INTEGER|
|INTERVAL|INTO|IS|
|ITERATE|JOIN|KEY|
|KEYS|KILL|LABEL|
|LEADING|LEAVE|LEFT|
|LIKE|LIMIT|LINEAR|
|LINES|LOAD|LOCALTIME|
|LOCALTIMESTAMP|LOCK|LONG|
|LONGBLOB|LONGTEXT|LOOP|
|LOW_PRIORITY|MATCH|MEDIUMBLOB|
|MEDIUMINT|MEDIUMTEXT|MIDDLEINT|
|MINUTE_MICROSECOND|MINUTE_SECOND|MOD|
|MODIFIES|NATURAL|NOT|
|NO_WRITE_TO_BINLOG|NULL|NUMERIC|
|ON|OPTIMIZE|OPTION|
|OPTIONALLY|OR|ORDER|
|OUT|OUTER|OUTFILE|
|PRECISION|PRIMARY|PROCEDURE|
|PURGE|RAID0|RANGE|
|READ|READS|REAL|
|REFERENCES|REGEXP|RELEASE|
|RENAME|REPEAT|REPLACE|
|REQUIRE|RESTRICT|RETURN|
|REVOKE|RIGHT|RLIKE|
|SCHEMA|SCHEMAS|SECOND_MICROSECOND|
|SELECT|SENSITIVE|SEPARATOR|
|SET|SHOW|SMALLINT|
|SPATIAL|SPECIFIC|SQL|
|SQLEXCEPTION|SQLSTATE|SQLWARNING|
|SQL_BIG_RESULT|SQL_CALC_FOUND_ROWS|SQL_SMALL_RESULT|
|SSL|STARTING|STRAIGHT_JOIN|
|TABLE|TERMINATED|THEN|
|TINYBLOB|TINYINT|TINYTEXT|
|TO|TRAILING|TRIGGER|
|TRUE|UNDO|UNION|
|UNIQUE|UNLOCK|UNSIGNED|
|UPDATE|USAGE|USE|
|USING|UTC_DATE|UTC_TIME|
|UTC_TIMESTAMP|VALUES|VARBINARY|
|VARCHAR|VARCHARACTER|VARYING|
|WHEN|WHERE|WHILE|
|WITH|WRITE|X509|
|XOR|YEAR_MONTH|ZEROFILL|
[/table]
  • 0
    点赞
  • 2
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值