摘要:
阅读全文
摘要:
TIMESTAMPDIFF(YEAR, `r`.`brithdate`, CURDATE()) AS 'age' CONCAT(TIMESTAMPDIFF(YEAR, r.brithdate, CURDATE()),'岁',(r.brithdate mod 12 ),'个月') AS 'age' 阅读全文
摘要:
ifnull(SUM(`m`.`right_eyesight` REGEXP '[0-9]+' OR `m`.`left_eyesight` REGEXP '[0-9]+'),0) AS '视力检测人数' NOT REGEXP '[0-9]+' 阅读全文