mysql常用查询

 

group by

SELECT
    name,
    sum(num)
FROM
    ***
WHERE
    a = 'bbb'
    and FROM_UNIXTIME(create_time, '%Y-%m-%d %H:%i:%S') > '2019-09-09 23:25:04'
    GROUP BY id