5，mysql查询文章字数

SELECT COUNT(*) FROM phome_ecms_news_data_1

　　6，MYSQL获取字段汉字的字数

SELECT *,CHAR_LENGTH(newstext) FROM phome_ecms_news_data_1

　　7，查看最大连接数

show variables like '%max_connection%';

　　获取字段总数(代码和标签符号表名字：phome_ecms_news 字段：smalltext)

select sum(CHAR_LENGTH(smalltext)) as total from phome_ecms_news

　　获取字段总数万分之排序加上小数点2位数(包括代码和标签符号phome_ecms_news 字段：smalltext)

select CONVERT(sum(CHAR_LENGTH(smalltext))/10000,DECIMAL(10,2)) as total from phome_ecms_news

　　获取字段总数万分之排序加整数四舍五入

select CONVERT(sum(CHAR_LENGTH(smalltext))/10000,SIGNED) as total from phome_ecms_news