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 (`)
精彩评论