随笔分类 - 分布式数据库
摘要:生日(DATE)计算方法1:YEAR(CURDATE())-YEAR(birthday)-(RIGHT(CURDATE(),5)<RIGHT(birthday,5))计算方法2:year( from_days( datediff( now( ), birthdate))) now() 当前时间,精确...
阅读全文
摘要:mysql默认是不能自定义函数的当create function时This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binarysolution 1:exec:SET G...
阅读全文

浙公网安备 33010602011771号