随笔分类 -  分布式数据库

摘要:生日(DATE)计算方法1:YEAR(CURDATE())-YEAR(birthday)-(RIGHT(CURDATE(),5)<RIGHT(birthday,5))计算方法2:year( from_days( datediff( now( ), birthdate))) now() 当前时间,精确... 阅读全文
posted @ 2014-09-22 10:27 fenglie 阅读(13715) 评论(1) 推荐(1)
摘要:mysql默认是不能自定义函数的当create function时This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binarysolution 1:exec:SET G... 阅读全文
posted @ 2014-09-18 10:24 fenglie 阅读(650) 评论(0) 推荐(0)

版权所有,转载声明