Home > Article > Backend Development > mysql语法问题
mysql语法问题
- WBOYOriginal
- 2016-06-20 12:57:081043browse
SELECT (`aaa`/`bbb`) AS cccFROM testWHERE ccc > 1
搜寻是没问题，但是加上WHERE条件会说[Err] 1054 - Unknown column 'ccc' in 'where clause'，请问要怎么修正?
回复讨论(解决方案)
SELECT (`aaa`/`bbb`) AS cccFROM testWHERE `aaa`/`bbb` > 1或
SELECT (`aaa`/`bbb`) AS cccFROM testHAVING ccc > 1
注意：`aaa`/`bbb` 不会被重复计算
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：安装php-5.3.28 时问题Next article：php远程连接服务器报错。