开发者

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

开发者 https://www.devze.com 2023-02-07 13:03 出处:网络
Yeah,this is reall weired, we are using microsoft access 2010 for java ..开发者_StackOverflow社区. then here is my printout sql statement

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

精彩评论

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