SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE students (stud_ID int AUTO_INCREMENT KEY, no_zk varchar(6), kurs varchar(1), spec varchar(7), gr varchar(2)); insert into students (no_zk,kurs,spec,gr) values ('202201','1','АМОЕ','22'), ('202202','1','МАЕ','30'), ('202203','1','МАЕ','30'), ('202204','1','АМОЕ','22'), ('202205','1','АМОЕ','22'), ('202206','1','АМОЕ','22'), ('202207','1','МАЕ','30'), ('202208','1','АМОЕ','22'); select * from students; DROP TRIGGER IF EXISTS `students_constraints_insert` ; DELIMITER $$ CREATE TRIGGER tr 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; END $$ DELIMITER ; insert into students (no_zk,kurs,spec,gr) values ('202209','8','АМОЕ','AA'); select * from students;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear