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')'(单引号内可以是其它的,这是语法错误,检查下拼写啥的……还有别的再补充)