【mysql】mysql函数相关

avg

用sql的avg（score）求完平均值后，保存两位小数的方法

select round(avg(pri_store_size),2) from es_index where index_pattern = 'logstash-tftech-fastservice-*';

format_bytes

SELECT format_bytes(512), format_bytes(18446644073709551615);

+-------------------+------------------------------------+
| format_bytes(512) | format_bytes(18446644073709551615) |
+-------------------+------------------------------------+
| 512 bytes         | 16383.91 PiB                       |
+-------------------+------------------------------------+