Home >Backend Development >PHP Tutorial >mysql语法有关问题
mysql语法有关问题
- WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
- 2016-06-13 12:19:131192browse
mysql语法问题
<br />SELECT (`aaa`/`bbb`) AS ccc<br />FROM test<br />WHERE ccc > 1<br />
搜寻是没问题，但是加上WHERE条件会说[Err] 1054 - Unknown column 'ccc' in 'where clause'，请问要怎么修正?
------解决思路----------------------
SELECT (`aaa`/`bbb`) AS ccc<br />FROM test<br />WHERE `aaa`/`bbb` > 1<br />或
SELECT (`aaa`/`bbb`) AS ccc<br />FROM test<br />HAVING 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远程连接服务器报错。该如何解决Next article：php透过统一发放tickets实现单点登陆SSO功能