MySQL的一些报错信息

1.【报错】Unknown column 'XXXX' in having clause

可改为having max(Salary)

 

 

 2.【报错】Operand should contain 1 column(s)

in后只能有一个字段

 

 

 3.【报错】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')'（单引号内可以是其它的，这是语法错误，检查下拼写啥的……还有别的再补充）