mysql觸發(fā)器

--testtable

delimiter //
create trigger insertTrigger before insert on testtable
for each row set new.w = new.a + new.b + new.c + new.d;
//

create trigger updateTrigger before update on testtable
for each row set new.w = new.a + new.b + new.c + new.d;
//

delimiter ;