举例：SELECT (@i:=@i+1) AS PM,A.*, U.TNAME, U.ID_NUM, U.ORG_NAME, CASE WHEN U.SEXFLAG=1 THEN ‘男’ WHEN U.SEXFLAG=2 THEN ‘女’ ELSE ” END SEX, CASE WHEN LENGTH(ID_NUM) = 18 THEN YEAR(NOW()) – CAST(SUBSTRING(ID_NUM, 7, 4) 开发云主机域名AS SIGNED) ELSE ” END AS AGE FROM TB_GH_MARATHON A LEFT JOIN TB_GH_USER U ON A.USER_ID = U.USER_ID ,(SELECT @i:=0) t WHERE 1=1 AND A.STATE = ‘1’加上红色字体的代码即可
举例：SELECT (@i:=@i+1) AS PM,A.*, U.TNAME, U.ID_NUM, U.ORG_NAME, CASE WHEN U.SEXFLAG=1 THEN ‘男’ WHEN U.SEXFLAG=2 THEN ‘女’ ELSE ” EN…
免责声明：本站发布的图片视频文字，以转载和分享为主，文章观点不代表本站立场，本站不承担相关法律责任；如果涉及侵权请联系邮箱：360163164@qq.com举报，并提供相关证据，经查实将立刻删除涉嫌侵权内容。
微信扫一扫 
