表名是数字开头的,在sql中必须得用[ ]把表名括起来
SELECT *
FROM 7Cai
WHERE UserName = 'keao' AND AttID = 'A002'
这样会提示:
"第 1 行: 7附近有语法错误。"
正确写法:
SELECT *
FROM [7Cai]
WHERE UserName = 'keao' AND AttID = 'A002'
表名是数字开头的,在sql中必须得用[ ]把表名括起来
SELECT *
FROM 7Cai
WHERE UserName = 'keao' AND AttID = 'A002'
这样会提示:
"第 1 行: 7附近有语法错误。"
正确写法:
SELECT *
FROM [7Cai]
WHERE UserName = 'keao' AND AttID = 'A002'