1.更新时候的if与else判断
更新t_task表id为1,当uid_list是空时为2020,不然拼接uid_list原内容与,2020 然后将值赋给uid_list 以end结束条件
update t_task set uid_list=case when uid_list is NULL then '2020' else CONCAT(uid_list,',2020') end WHERE id=1
更新t_task表id为1,当uid_list是空时为2020,不然拼接uid_list原内容与,2020 然后将值赋给uid_list 以end结束条件
update t_task set uid_list=case when uid_list is NULL then '2020' else CONCAT(uid_list,',2020') end WHERE id=1