Advertisement
akozhomka

Untitled

Sep 16th, 2021
59
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 check_nova_poshta_spd_id_before_update
  2.     before update
  3.     on order_ttn_settings
  4.     for each row
  5. BEGIN
  6.     IF NEW.spd_id IS NULL AND (NEW.is_active_beznal IS NULL OR NEW.is_active_beznal = 0) THEN
  7.         SIGNAL SQLSTATE '45000' SET message_text = 'Заполните поле spd_id';
  8.     END IF;
  9. END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement