mysql 函数大全-简单的总结，便于记忆

简单的总结，便于记忆。

日期时间函数：
NOW()-------------------------------系统当前的日期时间
year()------------------------------返回一个日期的年份部分
month()-----------------------------返回一个日期的月份部分
Date() -----------------------------返回日期时间的日期部分
Day() ------------------------------返回一个人日期的天数部分
Dayofweek()-------------------------返回一个日期对应的星期部分
hour() -----------------------------返回一个时间的小时部分
minute()----------------------------返回一个时间的分钟部分
second()----------------------------返回一个时间的秒部分
CurTime()---------------------------返回当前的时间
CurDate()---------------------------返回当前日期
Day-format()------------------------返回一个格式化的日期时间字符串
AddDate()---------------------------增加一个日期（天，周等）
AddTime()---------------------------增加一个时间（时，分等）
DateDiff()--------------------------计算两个日期之差
Date_add()--------------------------高度灵活的日期运算函数

日常文本函数
left()-----------------------------返回左边的字符串
right()----------------------------返回右边的字符串
Ltrim()----------------------------去掉左边的空格
Rtrim()----------------------------去掉右边的空格
Trim()-----------------------------去掉两边的空格
upper()-----------------------------将字符串转换成大写
lower()-----------------------------将字符串转换成小写
length()----------------------------返回字符串的长度
locate()----------------------------找出串的一个子串
substring()-------------------------返回子串
soundex()---------------------------返回串的soundex的值

数值处理函数
Abs()------------------------------绝对值
sqrt()-----------------------------开平方根
sin()------------------------------正玄函数
tan()------------------------------正切喊杀声
rand()-----------------------------返回一个随机数
cos()------------------------------余玄函数
mod()------------------------------返回除以一个数的余数
exp()------------------------------返回一个数的指数值
pi()-------------------------------返回圆周率

select 10 mod(3)-------------------计算10除以3的模

聚集函数（组函数）

cont()-----------------------------计算某列的行数
max()------------------------------计算某列的最大值
min()------------------------------计算某列的最小值
sum()------------------------------计算某列的和
avg()------------------------------计算某列的平均值

select子句的顺序

select
 from
   where
     group by
       having
         orde by
            limit

专家QQ2918386045_百度搜索   baidu.com/s?word=2918386045&tn=site888_pg&lm=-1
电话15124585814-百度搜索   baidu.com/s?wd=15124585814&pn=0&tn=site888_pg&ie=utf-8&usm=1
 qing.blog.sina.com.cn/3648472783/d97746cf32004gf5.html
 qing.blog.sina.com.cn/3648472783/d97746cf32004gf6.html
 qing.blog.sina.com.cn/3648472783/d97746cf32004gf7.html
 qing.blog.sina.com.cn/3648472783/d97746cf32004gf8.html
 qing.blog.sina.com.cn/3648472783/d97746cf32004gf9.html
 qing.blog.sina.com.cn/3648472783/d97746cf32004gfa.html
 qing.blog.sina.com.cn/3648472783/d97746cf32004gfb.html
 qing.blog.sina.com.cn/3648472783/d97746cf32004gfc.html
 qing.blog.sina.com.cn/3648472783/d97746cf32004gfd.html
 qing.blog.sina.com.cn/3648472783/d97746cf32004gfe.html
 qing.blog.sina.com.cn/3623477954/d7f9e2c232004pk4.html
 qing.blog.sina.com.cn/3623477954/d7f9e2c232004pk5.html
 qing.blog.sina.com.cn/3623477954/d7f9e2c232004pk6.html
 qing.blog.sina.com.cn/3623477954/d7f9e2c232004pk7.html
 qing.blog.sina.com.cn/3623477954/d7f9e2c232004pkc.html
 qing.blog.sina.com.cn/3623477954/d7f9e2c232004pkd.html
 qing.blog.sina.com.cn/3623477954/d7f9e2c232004pke.html
 qing.blog.sina.com.cn/3623477954/d7f9e2c232004pkf.html
 qing.blog.sina.com.cn/3623477954/d7f9e2c232004pkg.html
 qing.blog.sina.com.cn/3623477954/d7f9e2c232004pkh.html
 t.163.com/event/info/eventId/7942672374201462229
 t.163.com/event/info/eventId/-2105084014491587931
 t.163.com/event/info/eventId/1046981279714544435
 t.163.com/event/info/eventId/-1559830292391553207
 t.163.com/event/info/eventId/-1175117083884146301
 t.163.com/event/info/eventId/1575312199714051017
 t.163.com/event/info/eventId/-3422068140142696089
 t.163.com/event/info/eventId/6450527084224979906
 t.163.com/event/info/eventId/3943819207418695919
 t.163.com/event/info/eventId/9071315289574657628
 t.163.com/event/info/eventId/4010191309604141609
 t.163.com/event/info/eventId/4010191309604141609
 t.163.com/event/info/eventId/6326991362951528334
 230la.net/com/dfhjgkhhj/news/itemid-171602.html
 230la.net/com/dfhjgkhhj/news/itemid-171601.html
 230la.net/com/dfhjgkhhj/news/itemid-171603.html
 230la.net/com/dfhjgkhhj/news/itemid-171604.html
 230la.net/com/dfhjgkhhj/news/itemid-171605.html
 230la.net/com/dfhjgkhhj/news/itemid-171606.html
 230la.net/com/dfhjgkhhj/news/itemid-171607.html
 230la.net/com/dfhjgkhhj/news/itemid-171608.html
 230la.net/com/dfhjgkhhj/news/itemid-171609.html
 230la.net/com/dfhjgkhhj/news/itemid-171610.html
 230la.net/com/dfhfkjl/news/itemid-171612.html
 230la.net/com/dfhfkjl/news/itemid-171613.html
 230la.net/com/dfhfkjl/news/itemid-171614.html
 230la.net/com/dfhfkjl/news/itemid-171615.html
 230la.net/com/dfhfkjl/news/itemid-171616.html
 230la.net/com/dfhfkjl/news/itemid-171628.html
 230la.net/com/dfhfkjl/news/itemid-171629.html
 230la.net/com/dfhfkjl/news/itemid-171630.html
 230la.net/com/dfhfkjl/news/itemid-171631.html
 230la.net/com/dfhfkjl/news/itemid-171632.html
 230la.net/com/dhfhkgjl/news/itemid-171652.html
 230la.net/com/dhfhkgjl/news/itemid-171653.html
 230la.net/com/dhfhkgjl/news/itemid-171654.html
 230la.net/com/dhfhkgjl/news/itemid-171656.html
 230la.net/com/dhfhkgjl/news/itemid-171656.html
 230la.net/com/dhfhkgjl/news/itemid-171657.html
 230la.net/com/dhfhkgjl/news/itemid-171658.html
 230la.net/com/dhfhkgjl/news/itemid-171659.html
 230la.net/com/dhfhkgjl/news/itemid-171660.html
 230la.net/com/dhfhkgjl/news/itemid-171661.html
 photo.163.com/sgddjgkyr/#m=2&aid=260016820&pid=8504528210
 photo.163.com/sgddjgkyr/#m=2&aid=260016820&pid=8504498454
 photo.163.com/sgddjgkyr/#m=2&aid=260016820&pid=8504528198
 photo.163.com/sgddjgkyr/#m=2&aid=260016820&pid=8504508296
 photo.163.com/sgddjgkyr/#m=2&aid=260016820&pid=8504558094
 photo.163.com/sgddjgkyr/#m=2&aid=260016820&pid=8504538126
 photo.163.com/sgddjgkyr/#m=2&aid=260016820&pid=8504538123
 photo.163.com/sgddjgkyr/#m=2&aid=260016820&pid=8504528194
 photo.163.com/sgddjgkyr/#m=2&aid=260016820&pid=8504528193
 photo.163.com/sgddjgkyr/#m=2&aid=260016820&pid=8504498445
 photo.163.com/sghfkjgkj/#m=2&aid=260016838&pid=8504499498
 photo.163.com/sghfkjgkj/#m=2&aid=260016838&pid=8504549084
 photo.163.com/sghfkjgkj/#m=2&aid=260016838&pid=8504539125
 photo.163.com/sghfkjgkj/#m=2&aid=260016838&pid=8504499487
 photo.163.com/sghfkjgkj/#m=2&aid=260016838&pid=8504559093
 photo.163.com/sghfkjgkj/#m=2&aid=260016838&pid=8504559090
 photo.163.com/sghfkjgkj/#m=2&aid=260016838&pid=8504539123
 photo.163.com/sghfkjgkj/#m=2&aid=260016838&pid=8504549075
 photo.163.com/sghfkjgkj/#m=2&aid=260016838&pid=8504529244
 photo.163.com/sghfkjgkj/#m=2&aid=260016838&pid=8504499474
 photo.163.com/sdzhdgjk/#m=2&aid=260016853&pid=8504560525
 photo.163.com/sdzhdgjk/#m=2&aid=260016853&pid=8504550532
 photo.163.com/sdzhdgjk/#m=2&aid=260016853&pid=8504500925
 photo.163.com/sdzhdgjk/#m=2&aid=260016853&pid=8504520626
 photo.163.com/sdzhdgjk/#m=2&aid=260016853&pid=8504550524
 photo.163.com/sdzhdgjk/#m=2&aid=260016853&pid=8504500922
 photo.163.com/sdzhdgjk/#m=2&aid=260016853&pid=8504550523
 photo.163.com/sdzhdgjk/#m=2&aid=260016853&pid=8504530701
 photo.163.com/sdzhdgjk/#m=2&aid=260016853&pid=8504510785
 photo.163.com/sdzhdgjk/#m=2&aid=260016853&pid=8504540546
 meilishuo.com/magazine/45401037
 meilishuo.com/magazine/45401071
 meilishuo.com/magazine/45401117
 meilishuo.com/magazine/45401151
 meilishuo.com/magazine/45401317
 meilishuo.com/magazine/45401467
 meilishuo.com/magazine/45401505
 meilishuo.com/magazine/45401551
 meilishuo.com/magazine/45401611
 meilishuo.com/magazine/45401663
 meilishuo.com/magazine/45401709
 meilishuo.com/magazine/45401749
 qing.blog.sina.com.cn/3641790687/d91150df320045b4.html
 qing.blog.sina.com.cn/3641790687/d91150df320045b6.html
 qing.blog.sina.com.cn/3641790687/d91150df320045b8.html
 qing.blog.sina.com.cn/3641790687/d91150df320045b9.html
 qing.blog.sina.com.cn/3641790687/d91150df320045ba.html
 qing.blog.sina.com.cn/3641790687/d91150df320045bb.html
 qing.blog.sina.com.cn/3648472783/d97746cf32004gez.html
 qing.blog.sina.com.cn/3648472783/d97746cf32004gf0.html
 qing.blog.sina.com.cn/3648472783/d97746cf32004gf2.html
 qing.blog.sina.com.cn/3648472783/d97746cf32004gf3.html
 qing.blog.sina.com.cn/3648472783/d97746cf32004gf4.html
 qing.blog.sina.com.cn/3641790687/d91150df320045aq.html
 qing.blog.sina.com.cn/3641790687/d91150df320045ar.html
 qing.blog.sina.com.cn/3641790687/d91150df320045as.html
 qing.blog.sina.com.cn/3641790687/d91150df320045au.html
 qing.blog.sina.com.cn/3641790687/d91150df320045av.html
 qing.blog.sina.com.cn/3641790687/d91150df320045aw.html
 qing.blog.sina.com.cn/3641790687/d91150df320045ax.html
 qing.blog.sina.com.cn/3641790687/d91150df320045ay.html
 qing.blog.sina.com.cn/3641790687/d91150df320045b0.html
 qing.blog.sina.com.cn/3641790687/d91150df320045b1.html
 meilishuo.com/magazine/45398617
 meilishuo.com/magazine/45398777
 meilishuo.com/magazine/45398833
 meilishuo.com/magazine/45398891
 meilishuo.com/magazine/45398949
 meilishuo.com/magazine/45400343
 meilishuo.com/magazine/45400567
 meilishuo.com/magazine/45400827
 meilishuo.com/magazine/45400923
 meilishuo.com/magazine/45400961