AccessµÄ±íÖн¨µÄGroup×Ö¶ÎΪʲôÓÃsqlÓï¾äÎÞ·¨ÐÞ¸Ä
ͬÑùµÄtext×ֶΡ£±ðµÄ¶¼ÐС£Group¾Í²»ÐÐ //Õý³£ String sqlinto = "insert into User(PassWord) values('"+ "User" +"')"; stmt.executeUpdate(sqlinto); //ʧ°Ü String sqlinto = "insert into User(Group) values('"+ "User" + "')"; stmt.executeUpdate(sqlinto); ʧ°ÜÌáʾ java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
ÖªµÀÁË¡£¡£ºÍSQLÓï¾äÖеÄ×Ö¶ÎÓëACCESSϵͳÄÚÖÃ×ֶγåÍ»ÁË¡£ ÓÃ[Group]¾Í½â¾öÁË ¹Ø¼ü×Ö×Ö¶ÎÓÃ[]À¨ÆðÀ´¾ÍÐÐÁË¡£ÒýÓà ֪µÀÁË¡£¡£ºÍSQLÓï¾äÖеÄ×Ö¶ÎÓëACCESSϵͳÄÚÖÃ×ֶγåÍ»ÁË¡£ ÓÃ[Group]¾Í½â¾öÁË ¹Ø¼ü×Ö¡£¡£
Ïà¹ØÎÊ´ð£º
ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ ÀýÈç£ ......
select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ' select cast(convert(numeric(18,2),1275674000000/100000000)as real) ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......
ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð» ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡ ¹Ø×¢¡«¡« Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿ ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£ ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î date(Ö÷) outid(Ö÷) inid(Ö÷) num amt 2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle) ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄǰ2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......