hanyeah

转自：http://www.cnblogs.com/hateyoucode/archive/2010/05/08/1730526.html

sql语句没有写错，却一直报错“insert 语句语法错误”。原来是关键字冲突了。

insert into 语句的语法错误经常会出现,主要原因是数据的字段名为access或sql数据库的保留字

解决的方法很简单,一是可以直接改掉那些字段名,二是在代码中将字段名用中括号"[ ]"括起来即可.．

当然，要是熟悉access或sql数据库的保留字，就不会有这样的烦恼．以下是SQL和ACCESS保留字，供大家参考：

在开发网店下载专家v3.0.0时，写入数据库的其中一个insert into 语句总是报错，可怜我花了一个多小时查错却一无所获，真衰啊。原来是因为表中的一个字段名设为了Moduel，丫的，原来是保留字！！！

特此写下此文，严重警告自己不要在范这种低级错误了！！

SQL和ACCESS保留字

SQL保留字 
action add aggregate all 
alter after and as 
asc avg avg_row_length auto_increment 
between bigint bit binary 
blob bool both by 
cascade case char character 
change check checksum column 
columns comment constraint create 
cross current_date current_time current_timestamp 
data database databases date 
datetime day day_hour day_minute 
day_second dayofmonth dayofweek dayofyear 
dec decimal default delayed 
delay_key_write delete desc describe 
distinct distinctrow double drop 
end else escape escaped 
enclosed enum explain exists 
fields file first float 
float4 float8 flush foreign 
from for full function 
global grant grants group 
having heap high_priority hour 
hour_minute hour_second hosts identified 
ignore in index infile 
inner insert insert_id int 
integer interval int1 int2 
int3 int4 int8 into 
if is isam join 
key keys kill last_insert_id 
leading left length like 
lines limit load local 
lock logs long longblob 
longtext low_priority max max_rows 
match mediumblob mediumtext mediumint 
middleint min_rows minute minute_second 
modify month monthname myisam 
natural numeric no not 
null on optimize option 
optionally or order outer 
outfile pack_keys partial password 
precision primary procedure process 
processlist privileges read real 
references reload regexp rename 
replace restrict returns revoke 
rlike row rows second 
select set show shutdown 
smallint soname sql_big_tables sql_big_selects 
sql_low_priority_updates sql_log_off sql_log_update sql_select_limit 
sql_small_result sql_big_result sql_warnings straight_join 
starting status string table 
tables temporary terminated text 
then time timestamp tinyblob 
tinytext tinyint trailing to 
type use using unique 
unlock unsigned update usage 
values varchar variables varying 
varbinary with write when 
where year year_month zerofill

ACCESS保留字
Microsoft Access 版本：1.0 , 1.1 , 2.0 
Microsoft Access for Windows 95, version 7.0 
Microsoft Access 97

本片文章中所列的单词和符号是保留字，应避免在Ａｃｃｅｓｓ字段名和变量名中使用，因为这些保留字在Access和Microsoft Jet database系统中有其特定的含义，如果你使用，将会出错。
-A
ADD
ALL (2.0, 7.0, 97)
Alphanumeric
ALTER
AND
ANY (2.0, 7.0, 97)
Application
AS
ASC
Assistant
AUTOINCREMENT
Avg

-B

BETWEEN
BINARY
BIT
BOOLEAN
BY
BYTE

-C

CHAR, CHARACTER
COLUMN
CompactDatabase (2.0, 7.0, 97)
CONSTRAINT
Container (2.0, 7.0, 97)
Count
COUNTER (2.0, 7.0, 97)
CREATE
CreateDatabase (2.0, 7.0, 97)
CreateField (2.0, 7.0, 97)
CreateGroup (2.0, 7.0, 97)
CreateIndex (2.0, 7.0, 97)
CreateObject (2.0, 7.0, 97)
CreateProperty (2.0, 7.0, 97)
CreateRelation (2.0, 7.0, 97)
CreateTableDef (2.0, 7.0, 97)
CreateUser (2.0, 7.0, 97)
CreateWorkspace (2.0, 7.0, 97)
CURRENCY
CurrentUser (2.0, 7.0, 97)

-D

DATABASE (2.0, 7.0, 97)
DATE (2.0, 7.0, 97)
DATETIME
DELETE
DESC
Description
DISALLOW
DISTINCT
DISTINCTROW
Document (2.0, 7.0, 97)
DOUBLE (2.0, 7.0, 97)
DROP

-E
Echo (2.0, 7.0, 97)
Else
End
Eqv
Error
EXISTS (2.0, 7.0, 97)
Exit

-F

FALSE
Field, Fields (2.0, 7.0, 97)
FillCache (2.0, 7.0, 97)
FLOAT, FLOAT4, FLOAT8
FOREIGN (2.0, 7.0, 97)
Form, Forms
FROM
Full (2.0, 7.0, 97)
FUNCTION

-G

GENERAL
GetObject (2.0, 7.0, 97)
GetOption (2.0, 7.0, 97)
GotoPage
GROUP (2.0, 7.0, 97)
GROUP BY
GUID (7.0, 97)

-H

HAVING

-I[/color

Idle (2.0, 7.0, 97)
IEEEDOUBLE, IEEESINGLE
If
IGNORE (2.0, 7.0, 97)
Imp
IN, In
INDEX
Index, Indexes (2.0, 7.0, 97)
INNER
INSERT
InsertText (2.0, 7.0, 97)
INT, INTEGER, INTEGER1, INTEGER2, INTEGER4
INTO
IS, Is

-J

JOIN

-K

KEY (2.0, 7.0, 97)

-L

LEFT
Level
Like
LOGICAL, LOGICAL1
LONG, LONGBINARY, LONGTEXT

-M

Macro
Match (2.0, 7.0, 97)
Max, Min, Mod
MEMO
Module
MONEY
Move (2.0, 7.0, 97)

-N

NAME (2.0, 7.0, 97)
NewPassword (2.0, 7.0, 97)
NO
Not
NULL
NUMBER, NUMERIC

-O

Object (2.0, 7.0, 97)
OLEOBJECT (2.0, 7.0, 97)
OFF
ON
OpenRecordset (2.0, 7.0, 97)
OPTION
OR, Or
ORDER
Outer (2.0, 7.0, 97)
OWNERACCESS

-P

Parameter (2.0, 7.0, 97)
PARAMETERS
Partial (2.0, 7.0, 97)
PERCENT (2.0, 7.0, 97)
PIVOT
PRIMARY
PROCEDURE
Property (2.0, 7.0, 97)

-Q

Queries
Query
Quit (2.0, 7.0, 97)

-R

REAL
Recalc (2.0, 7.0, 97)
Recordset (2.0, 7.0, 97)
REFERENCES
Refresh
RefreshLink (2.0, 7.0, 97)
RegisterDatabase (2.0, 7.0, 97)
Relation (2.0, 7.0, 97)
Repaint (2.0, 7.0, 97)
RepairDatabase (2.0, 7.0, 97)
Report
Reports
Requery
RIGHT

-S

SCREEN
SECTION
SELECT (2.0, 7.0, 97)
SET
SetFocus (2.0, 7.0, 97)
SetOption (2.0, 7.0, 97)
SHORT
SINGLE (2.0, 7.0, 97)
SMALLINT (2.0, 7.0, 97)
SOME (2.0, 7.0, 97)
SQL
StDev, StDevP
STRING
Sum

-T

TABLE
TableDef, TableDefs (2.0, 7.0, 97)
TableID
TEXT
TIME, TIMESTAMP (2.0, 7.0, 97)
TOP (2.0, 7.0, 97)
TRANSFORM
TRUE
Type

-U

UNION
UNIQUE
UPDATE

-V

VALUE
VALUES (2.0, 7.0, 97)
Var, VarP
VARBINARY, VARCHAR (2.0, 7.0, 97)

-W

WHERE
WITH
Workspace (2.0, 7.0, 97)

-X

Xor

[color=red]-Y[/color

Year
YES
YESNO (2.0, 7.0, 97)

下面的符号不能在字段的设计中使用

.
/ 
* :
! #
&
-