// An highlighted block
select uid,username,`password`,email,myid,myidkey,regip,regdate,lastloginip,
case lastlogintime
WHEN 0 THEN
'null'
END '上次登陆时间',
case salt
WHEN null THEN
'null'
END 'salt',
case secques
WHEN null THEN
'null'
END 'secques',
case mobile
WHEN null THEN
'null'
END 'mobile'
FROM members
mysql的case when
最新推荐文章于 2024-07-24 21:47:59 发布