如何使用MySQL查询仅按当前月份的源ID进行总计

Question

I have this table in MySQL

source amount for_date
1        100   2019-01-15
1        200   2019-01-16
1        200   2019-02-16
2        350   2019-02-14

SELECT SUM(amount) amountSum FROM Flow WHERE source='1' GROUP BY month(for_date)

This MySQL query work, but I want to get only the current month, not the month before.

Answer 1

Filter the month with where condition

Month only

SELECT SUM(amount) amountSum FROM Flow WHERE source='1' AND month(for_date)=month(now()) GROUP BY month(for_date)

With year

 SELECT SUM(amount) amountSum FROM Flow WHERE source='1' AND month(for_date)=month(now()) AND year(for_date)=year(now()) GROUP BY month(for_date)