mysql - MYSQL多列总和

Question

请帮我得到总和...

select SUM(free),SUM(Paid),SUM(Guest)
from food_regs
where start date= 'date' and end date ='date'

Answer 1

根据您的问题，我假设您需要特定日期的三个字段的总和。

然后尝试以下查询

select free+paid+guest from food_regs where start date= 'date' and end date ='date';