Advertisement
ganryu

Untitled

Nov 19th, 2015
151
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.31 KB | None | 0 0
  1. CREATE DEFINER=`root`@`localhost` TRIGGER `desarrollo`.`producto_AFTER_INSERT` AFTER INSERT ON `producto` FOR EACH ROW
  2. BEGIN
  3.     SET SQL_SAFE_UPDATES = 0;
  4.        
  5.     INSERT INTO inventario(stock, producto_id, sucursal_id, habilitado)
  6.     SELECT 0, NEW.id, sucursal.id, 1
  7.     FROM sucursal;
  8.        
  9.     SET SQL_SAFE_UPDATES=1;
  10. END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement