SQLize | PHPize | SQLtest

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 SET NEW.kurs = 0; END $$ DELIMITER ; insert into students (no_zk,kurs,spec,gr) values ('202209','1','АМОЕ','22'); select * from students;