Java/MySQL : Insert date gives "Unknown column ' date'"even though its there (Error 1054 (42s22))

Question

有人可以告诉我我在这里做错了什么吗？我有一个这样的表:

mysql> describe mytable;
Field       Type       Null     Key      Default      Extra
-----------+----------+--------+--------+------------+---------------
id          int(11)    NO       PRI      NULL         auto_increment
foreignid   int(11)    NO       MUL      NULL
date        date       NO                '0000-00-00'
[some more columns]

我正在尝试通过准备好的语句插入值:

String insert = "insert into mytable (foreignid, date) values (?, ?)";
PreparedStatement pst = connection.prepareStatement(insert);
pst.setInt(1, newForeignID);     //valid foreign key
pst.setDate(2, newDate);         //newDate is a proper java.sql.Date
pst.execute();

这应该相当简单，但我总是收到此错误:

Unknown column 'date' in 'field list'

知道为什么会发生这种情况吗？

Answer 1

date是mysql中的一个关键字。您应该逃避或更好地重命名它:

String insert = "insert into mytable (foreignid, `date`) values (?, ?)";