每日统计 SELECT SUM(CASE WHEN type = '1' THEN money ELSE 0 END) AS total_in, SUM(CASE WHEN type = '2' THEN money ELSE 0 END) AS total_out, DATE_FORMAT(FROM_UNIXTIME(date),'%Y-%m-%d...