mysql下IF语句的简单使用

update if

update test set visit_age=if(visit_num is null,1,visit_num+1) where id=1

select if

select distinct if(exists(select * from interface_view_groups where id= %s and project_id= %s),1,0) as isexist