Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > mysql语法问题

mysql语法问题

WBOY
Release： 2016-06-20 12:57:08
Original
1086 people have browsed it

SELECT (`aaa`/`bbb`) AS cccFROM testWHERE ccc > 1
Copy after login

搜寻是没问题，但是加上WHERE条件会说[Err] 1054 - Unknown column 'ccc' in 'where clause'，请问要怎么修正?


回复讨论(解决方案)

SELECT (`aaa`/`bbb`) AS cccFROM testWHERE `aaa`/`bbb` > 1
Copy after login
或 
SELECT (`aaa`/`bbb`) AS cccFROM testHAVING ccc > 1
Copy after login


注意：`aaa`/`bbb` 不会被重复计算

Related labels：
mysql语法问题
source：php.cn
Previous article：安装php-5.3.28 时问题 Next article：php远程连接服务器报错。
Statement of this Website
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
Latest Articles by Author
Latest Issues
How to select multiple checkboxes in Reactjs I have a list of options in which I want to select multiple checkboxes but am unable to do...
From 2024-04-06 18:55:21
0
1
396
Scatterplot points do not maintain values ​​when zooming in d3.js This is my first time using d3.js, so please bear with me. I implemented it as pure JavaSc...
From 2024-04-06 18:16:26
0
1
403
React Three Fiber: Why are my scroll events lagging? In ReactThreeFiber, I have a React component that generates a sprite that I want to persis...
From 2024-04-06 13:39:24
0
1
410
Align tooltip to relative parent I spent two days trying to solve this problem but I realized I couldn't do it alone. I'm t...
From 2024-04-06 13:16:59
0
2
394
OAuth 2.0 configuration settings I'm using phpmailer to send mail through smtp.google.com server but now it's not working b...
From 2024-04-06 11:12:57
0
1
408
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template