CREATE TRIGGER ins_salary
BEFORE INSERT ON empsalary
FOR EACH ROW
SET NEW.salary = NEW.salary+2000;     -- salary insert korle age 2000 jog hobe tarpor insert hobe


CREATE TRIGGER ins_up_salary
BEFORE UPDATE ON empsalary
FOR EACH ROW
SET new.salary = new.salary-2000;    ---- jodi update kori tahole age trigger hoye 2000 minus korbe then hobe ja hobar