一条sql帮你弄懂他们之间的关系!
select ifnull("男",if(1!=1,"男","女")) as sex,ifnull(null,if(1!=1,"男","女")) as sex2,
ifnull(null,if(1=1,"男","女")) as sex3
结果:
根据数据库条件更新
连表更新,r表的operate_type字段,根据r表的common_group_id不同值福不容的值。
update table1 r
inner join table2 car on r.mid = car.mid
set r.operate_type = if(r.common_group_id=0,0,2),r.modifier= #{modifier},
r.is_deleted = if(r.common_group_id=0,1,0)
备注:
自己看着悟!