haxiaowei

摘要： 10.汇总数据 聚集函数 avg平均值，count行数，max最大值，min最小值，sum之和mysql> select msg,avg(msg) from pw_luck;+-----+----------+| msg | avg(msg) |+-----+----------+| 100 | ... 阅读全文

摘要： 9.数据处理函数 文本处理：Upper 大写mysql> select uid,name,msg, Upper(name) as UpperName from pw_luck;+-----+-----------+------+-----------+| uid | name | msg... 阅读全文