search

denisenkom / go-mssqldb

Microsoft SQL server driver written in go language
BSD 3-Clause "New" or "Revised" License
1.81k stars 493 forks source link

mssql sql bug #754

Open evmsoft opened 2 years ago

evmsoft commented 2 years ago

Describe the bug 在MSsql下，SELECT COUNT(1) FROM user WHERE passport='12345678'这个报错，user需要 [ ]起来


Exception message:
{
    "code": 52,
    "message": "mssql: 关键字 'user' 附近有语法错误。, SELECT COUNT(1) FROM user WHERE passport='12345678'\n",
    "data": null
}
tc-hib commented 2 years ago
  1. This is not an SQL Server help desk, your problem is not related to Go in any way
  2. The maintainers don't speak Chinese
  3. You got free software from them, you could make an effort to properly explain your problem
  4. Enclose "user" in brackets, or name it differently, close this issue and please don't do that a third time.