按表中的出生年月计算出年龄:
select *,DATE_FORMAT(FROM_DAYS(TO_DAYS(NOW())-TO_DAYS(userInfoBirthday)),'%Y')+0 AS age from store_userinfo where userId=8;
去掉数据首尾的空格:
trim(字段名);
按表中的出生年月计算出年龄:
select *,DATE_FORMAT(FROM_DAYS(TO_DAYS(NOW())-TO_DAYS(userInfoBirthday)),'%Y')+0 AS age from store_userinfo where userId=8;
去掉数据首尾的空格:
trim(字段名);