Guest User

Untitled

a guest
May 24th, 2018
92
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.24 KB | None | 0 0
  1. CREATE TRIGGER `tg_pod` AFTER INSERT ON podrazdelenie`
  2. FOR EACH ROW BEGIN
  3. SET @var:=LAST_INSERT_ID();
  4. SELECT @var2:=por_num FROM podrazdelenie WHERE id=@var;
  5. UPDATE podrazdelenie SET por_num=por_num+1 WHERE por_num>=@var2;
  6. END;|
Add Comment
Please, Sign In to add comment