MYSQL常用语句
根据条件求和(根据时间戳转月份求和)
SELECT SUM( money )
FROM `dr_member_cashlog`
WHERE FROM_UNIXTIME( paytime, '%Y-%m' ) = '2024-04'
根据条件求和(根据时间戳转月份求和)
SELECT SUM( money )
FROM `dr_member_cashlog`
WHERE FROM_UNIXTIME( paytime, '%Y-%m' ) = '2024-04'