摘要:
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 阅读全文
摘要:
转载:https://www.cnblogs.com/Fooo/p/9183661.html 查询所有数据库占用磁盘空间大小的SQL语句: select TABLE_SCHEMA, concat(truncate(sum(data_length)/1024/1024,2),' MB') as dat 阅读全文