关于SOL语句,请高手指点下..总提示FROM语句错误

set rs=server.createobject("adodb.recordset")
sql="select * from user where username='"&user&"'"
rs.open sql,conn,1,1

sql="select * from [user] where username='"&user&"'"
user是SQL里面的关键字，所以当你的表名和关键字重名时要加[]

user有没有定义？
你他!@#$%^&*也太小气了吧
0分，你怎么不去死呢

user 为SQL里的保留关键字，不得不使用关键字的时候，在SQL语句要把关键字用综括号引起来 [user]

除了user 以外，还有下列关键字，在写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