开发者

I got syntax error for SQL on java, where there isn't any error

Yeah,this is reall weired, we are using microsoft access 2010 for java ..开发者_StackOverflow社区. then here is my printout sql statement

DB Query:

INSERT INTO FileShare(source,destination,date)
VALUES ('C:\Users\JunHai\Documents\Scenario.docx',
          'C:\Users\JunHai\Desktop\dfdfd.docx','29/01/2011 00:34:33')

It totally seems alright, but it just keeping giving me syntax error ... who can really see the problem ?


Date's a reserved name, you'll have to surround it with backticks (`)

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜