CREATE TRIGGER BeforeInsertTestBEFORE INSERT ON changeFOR EACH ROWBEGIN UPDATE message SET dept = new.newdept WHERE mid = new.cid ;END;
