mysql查询结果0-1-2变成男-女-未知
select
case sex
when “0” then (‘男’)
when “1” then (‘女’)
when “2” then (‘未知’)
else null end as sex
form Table
mysql 查询的同时修改数据
update talbe set column=param, column2=param2 where id in (子查询{将想要修改的结果查询出来}) a
MYSQL 查询结果批量修改
UPDATE account
INNER JOIN ( SELECT id, contact FROM common) AS b ON account.user_id = b.id
SET account.user_name = b.contact WHERE ISNULL(account.user_name)
MySQL 查询结果替换
示例
如果 type 等于 -1 那么返回的结果就是 0
否则 还是返回 type的数值
SELECT IF(type=-1, 0, type) as type
FROM table1;
MySQL 替换字符串
将type字段里面的 aaa 替换为 bbb
select *,replace(type,“aaa”,“bbb”) as nowtype from table1;
mysql字符串拼接
示例
将 type." ".type1.“哈哈” 的形式 拼接新的字段
select *,CONCAT(type," ",type1,“哈哈”) as nowtype from table1;