mysql - org.hibernate.exception.SQLGrammarException : could not execute query : Incorrect syntax near the keyword 'user'

Question

我还有一个问题。它只在 MSSQL 服务器中给出:

select theme0_.id as id12_, theme0_.user as user12_, theme0_.theme as theme12_ 
from theme theme0_ where theme0_.user=1 

此查询出现错误:

Incorrect syntax near the keyword 'user'.

但是查询在 MySQL 服务器中正确执行。请帮我。谢谢!!

Answer 1

那是因为 USER 是 Reserve Word在 SQL Server 中，需要在查询中使用方括号 [] 进行转义。

然而 MySQL Reserve Words 的情况并非如此

您的查询应类似于

select [id] as id12_, 
[user] as user12_, 
[theme] as theme12_ 
from theme 
where [user] = 1