m0n0lithic

before_update_evento.sql

Dec 2nd, 2016
92
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.23 KB | None | 0 0
  1. DELIMITER $$
  2.  
  3. -- `before_update_evento` Trigger para pasar todo a mayuscula en nombrev
  4. CREATE TRIGGER `before_update_evento` BEFORE UPDATE ON `evento` FOR EACH ROW
  5. BEGIN SET NEW.nombrev=UCASE(NEW.nombrev);
  6. END;$$
  7.  
  8. DELIMITER ;
Advertisement
Add Comment
Please, Sign In to add comment