Posts by Euae Lucas • 3 points

• 0

  votes

  3

  answers

  402

  views

  Q: How to do an operation on a Trigger? MYSQL

  CREATE TRIGGER aumentarsalario AFTER INSERT ON empregados FOR EACH ROW BEGIN UPDATE EMPREGADOS SET SALARIO = NEW.SALARIO * (NEW.SALARIO*(10/100)) WHERE NEW.SALARIO < 900; END IF END How do I put…

  mysql sql

  asked 6 years, 6 months ago Euae Lucas 3