mysql触发器监控数据变化并设置表中其他字段

create trigger triggerStatus1
before update on dorm
for each row
begin
	if new.alreadyNumber=new.allNumber
	then 
		set new.status='是';
	end if;
	if new.alreadyNumber<>new.allNumber
	then
		set new.status='否';
	end if;
end;