Begin if (old.mobile_status = '2') and (new.mobile_status = '1') theninsert into jooj_jsm.jj_notice_send(vip_id,action,mp_id) values(new.vip_id,'1','11'); end if; end