SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
DROP TRIGGER IF EXISTS `students_constraints_insert`; CREATE TRIGGER `students_constraints_insert` BEFORE INSERT ON `Students` FOR EACH ROW BEGIN IF not(NEW.kurs >=1 and NEW.kurs <= 6) THEN SET NEW.kurs = 0; IF not(NEW.spec >= 'А' AND NEW.spec <= 'я') THEN SET NEW.spec = 0; IF not(NEW.gr >='01' AND NEW.gr <= '99') THEN SET NEW.gr = 0; END IF; END IF; END IF;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear