Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TRIGGER `tg_pod` AFTER INSERT ON podrazdelenie`
- FOR EACH ROW BEGIN
- SET @var:=LAST_INSERT_ID();
- SELECT @var2:=por_num FROM podrazdelenie WHERE id=@var;
- UPDATE podrazdelenie SET por_num=por_num+1 WHERE por_num>=@var2;
- END;|
Add Comment
Please, Sign In to add comment