#update user_auth_copy set nl= (substring(now(),1,4)-substring(card_no,7,4))-(substring(card_no,11,4)-date_format(now(),'%m%d')>0)
SELECT user_id as ID,realname as "姓名",sex as "性别",nl as "年龄",card_no as "身份证号",mobile as "手机号" FROM user_auth_copy WHERE nl >65
#SELECT * FROM user_auth_copy WHERE nl >65
sql语句根据身份证号获取年龄
于 2022-05-10 19:22:44 首次发布