单纯的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';
单纯的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';