You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version

记录一次数据库运行错误

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '（
是属于 SQL 语句错误

配置 mybatis 时发现此错误：

select * from user



#{uid}

看着没错，原因是 “and id in（” 中的 “（” 是中文符号，运行方法报：You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '（ 。

解决办法，把中文"（"符号改成英文 “(”。