评论字数长度分布测试

单纯的sql语句实现

创建临时表
create TABLE temp as SELECT LENGTH(content) as zishu,COUNT(*) as pinglunshu FROM `toal_ppx_database`.`mid_comments_ceshi` GROUP BY zishu

统计字数


SELECT sum(pinglunshu) FROM `toal_ppx_database`.`评论内容统计`  WHERE `zishu` >= '50';