INSERT INTO 语句的语法错误

今天使用access数据库 +c#报INSERT INTO 语句的语法错误,发现是关键字冲突

以下列出的是相关的ACCESS保留字,我下次一定要注意了。
Access 2002/2003

-A
      ADD
      ALL
      Alphanumeric
      ALTER
      AND
      ANY
      Application
      AS
      ASC
      Assistant
      AUTOINCREMENT
      Avg
-B
      BETWEEN
      BINARY
      BIT
      BOOLEAN
      BY
      BYTE
-C
      CHAR, CHARACTER
      COLUMN
      CompactDatabase
      CONSTRAINT
      Container
      Count
      COUNTER
      CREATE
      CreateDatabase
      CreateField
      CreateGroup
      CreateIndex
      CreateObject
      CreateProperty
      CreateRelation
      CreateTableDef
      CreateUser
      CreateWorkspace
      CURRENCY
      CurrentUser
-D
      DATABASE
      DATE
      DATETIME
      DELETE
      DESC
      Description
      DISALLOW
      DISTINCT
      DISTINCTROW
      Document
      DOUBLE
      DROP
-E
      Echo
      Else
      End
      Eqv
      Error
      EXISTS
      Exit
-F
      FALSE
      Field, Fields
      FillCache
      FLOAT, FLOAT4, FLOAT8
      FOREIGN
      Form, Forms
      FROM
      Full
      FUNCTION
-G
      GENERAL
      GetObject
      GetOption
      GotoPage
      GROUP
      GROUP BY
      GUID
-H
      HAVING
-I
      Idle
      IEEEDOUBLE, IEEESINGLE
      If
      IGNORE
      Imp
      IN
      INDEX
      Index, Indexes
      INNER
      INSERT
      InsertText
      INT, INTEGER, INTEGER1, INTEGER2, INTEGER4
      INTO
      IS
-J
      JOIN
-K
      KEY
-L
      LastModified
      LEFT
      Level
      Like
      LOGICAL, LOGICAL1
      LONG, LONGBINARY, LONGTEXT
        
-M
      Macro
      Match
      Max, Min, Mod
      MEMO
      Module
      MONEY
      Move
-N
      NAME
      NewPassword
      NO
      Not
      Note
      NULL
      NUMBER, NUMERIC
-O
      Object
      OLEOBJECT
      OFF
      ON
      OpenRecordset
      OPTION
      OR
      ORDER
      Orientation
      Outer
      OWNERACCESS
-P
      Parameter
      PARAMETERS
      Partial
      PERCENT
      PIVOT
      PRIMARY
      PROCEDURE
      Property
-Q
      Queries
      Query
      Quit
-R
      REAL
      Recalc
      Recordset
      REFERENCES
      Refresh
      RefreshLink
      RegisterDatabase
      Relation
      Repaint
      RepairDatabase
      Report
      Reports
      Requery
      RIGHT
-S
      SCREEN
      SECTION
      SELECT
      SET
      SetFocus
      SetOption
      SHORT
      SINGLE
      SMALLINT
      SOME
      SQL
      StDev, StDevP
      STRING
      Sum
-T
      TABLE
      TableDef, TableDefs
      TableID
      TEXT
      TIME, TIMESTAMP
      TOP
      TRANSFORM
      TRUE
      Type
-U
      UNION
      UNIQUE
      UPDATE
      USER
-V
      VALUE
      VALUES
      Var, VarP
      VARBINARY, VARCHAR
-W
      WHERE
      WITH
      Workspace
-X
      Xor
-Y
      Year
      YES
      YESNO
        
以及以下标点符号
     .
     /
     *
     ;
     :
     !
     #
     &
     -
     ?
     "
     '
     $


Access 2000

-A
      ADD
      ALL
      Alphanumeric
      ALTER
      AND
      ANY
      Application
      AS
      ASC
      Assistant
      AUTOINCREMENT
      Avg
-B
      BETWEEN
      BINARY
      BIT
      BOOLEAN
      BY
      BYTE
-C
      CHAR, CHARACTER
      COLUMN
      CompactDatabase
      CONSTRAINT
      Container
      Count
      COUNTER
      CREATE
      CreateDatabase
      CreateField
      CreateGroup
      CreateIndex
      CreateObject
      CreateProperty
      CreateRelation
      CreateTableDef
      CreateUser
      CreateWorkspace
      CURRENCY
      CurrentUser
-D
      DATABASE
      DATE
      DATETIME
      DELETE
      DESC
      Description
      DISALLOW
      DISTINCT
      DISTINCTROW
      Document
      DOUBLE
      DROP
-E
      Echo
      Else
      End
      Eqv
      Error
      EXISTS
      Exit
-F
      FALSE
      Field, Fields
      FillCache
      FLOAT, FLOAT4, FLOAT8
      FOREIGN
      Form, Forms
      FROM
      Full
      FUNCTION
-G
      GENERAL
      GetObject
      GetOption
      GotoPage
      GROUP
      GROUP BY
      GUID
-H
      HAVING
-I
      Idle
      IEEEDOUBLE, IEEESINGLE
      If
      IGNORE
      Imp
      IN
      INDEX
      Index, Indexes
      INNER
      INSERT
      InsertText
      INT, INTEGER, INTEGER1, INTEGER2, INTEGER4
      INTO
      IS
-J
      JOIN
-K
      KEY
-L
      LastModified
      LEFT
      Level
      Like
      LOGICAL, LOGICAL1
      LONG, LONGBINARY, LONGTEXT
        
-M
      Macro
      Match
      Max, Min, Mod
      MEMO
      Module
      MONEY
      Move
-N
      NAME
      NewPassword
      NO
      Not
      NULL
      NUMBER, NUMERIC
-O
      Object
      OLEOBJECT
      OFF
      ON
      OpenRecordset
      OPTION
      OR
      ORDER
      Orientation
      Outer
      OWNERACCESS

-P
      Parameter
      PARAMETERS
      Partial
      PERCENT
      PIVOT
      PRIMARY
      PROCEDURE
      Property
-Q
      Queries
      Query
      Quit
-R
      REAL
      Recalc
      Recordset
      REFERENCES
      Refresh
      RefreshLink
      RegisterDatabase
      Relation
      Repaint
      RepairDatabase
      Report
      Reports
      Requery
      RIGHT
-S
      SCREEN
      SECTION
      SELECT)
      SET
      SetFocus
      SetOption
      SHORT
      SINGLE
      SMALLINT
      SOME
      SQL
      StDev, StDevP
      STRING
      Sum
-T
      TABLE
      TableDef, TableDefs
      TableID
      TEXT
      TIME, TIMESTAMP
      TOP
      TRANSFORM
      TRUE
      Type
-U
      UNION
      UNIQUE
      UPDATE
      User
-V
      VALUE
      VALUES
      Var, VarP
      VARBINARY, VARCHAR
-W
      WHERE
      WITH
      Workspace
-X
      Xor
-Y
      Year
      YES
      YESNO
        


以及以下标点符号
     .
     /
     *
     :
     !
     #
     &
     -
     ?
     ;
     "
     '
     $

 

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值