Advertisement
Maks140888

Untitled

Jun 7th, 2022
1,311
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.32 KB | None | 0 0
  1. create trigger chek_group_lessons
  2.     BEFORE INSERT or UPDATE on sheldule
  3.     for each row
  4.     BEGIN
  5.         if (SELECT * from sheldule where group_id = :NEW.group_id and day_id = :NEW.day_id, and day.i)
  6.         THEN raise_application error (-20500, 'Group already had lesson in this moment');
  7.         end if;
  8.     end;
  9.    
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement