Mysql WHERE 子句不起作用? [英] Mysql WHERE clause not working?

问题描述

我在这里看了一堆文章，但我找不到我想要的东西

I've looked at a bunch of articles on here but I can't find quite what I'm looking for

SELECT SUM(adult) as adult_sold_1 WHERE showtime = '1'From tickets

这里一切正常，但是当我尝试使用 WHERE 时，整个事情停止工作......

Everything here works but when I try to use WHERE the entire thing stops working...

这是怎么回事?

还有办法一次做多个吗??

Also is there a way to do multiple at once??

喜欢

SELECT SUM(adult) as adult_sold_1 From tickets WHERE showtime = '1' 

那么大人点的学生也一样吗?

then the same thing with student in spot of adult?

推荐答案

SELECT 查询应该是这样的:

SELECT `field_name` FROM `table_name`

关于有 WHERE 子句:

On having WHERE clause:

SELECT `field_name` FROM `table_name` WHERE `field_name` = 'some_value'

在您的查询中，FROM 未写入 &并且没有正确放置.应该是这样的:

In your query, FROM is not written & and is not properly placed. It should be like:

SELECT SUM(`adult`) as adult_sold_1 FROM `tickets` WHERE `showtime` = '1'

SUM() 语法:

SELECT SUM(`column_name`) FROM `table_name` WHERE condition;

Multiple SUM() 示例:

例 1:-

SELECT SUM(CASE WHEN `item` = 'ABC' THEN `price` END) as ABC_price,
    SUM(CASE WHEN `item` = 'XYZ' THEN `price` END) as XYZ_price
FROM `item_table`

例 2:-

SELECT SUM(`price`) as total_price, SUM(`quantity`) as total_quantity FROM `item_table`

这篇关于Mysql WHERE 子句不起作用?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！