可以用在select中:
select nick_name as '昵称',if(sex=1,'男','女') as 性别 from tb_shop_user
也可以用在update中用作批量修改数据 如果能被2整除则为1否则为2
update tb_shop_goods set GOODS_TYPE=(if(goods_id%2=0,1,2))
可以用在select中:
select nick_name as '昵称',if(sex=1,'男','女') as 性别 from tb_shop_user
也可以用在update中用作批量修改数据 如果能被2整除则为1否则为2
update tb_shop_goods set GOODS_TYPE=(if(goods_id%2=0,1,2))