jvyrjcEe

1DROP TABLE IF EXISTS students;
2CREATE TABLE students(
3    id int AUTO_INCREMENT,
4    emri varchar(100) NOT NULL,
5    mesatarja int,
6    mesazhi varchar(200),
7    PRIMARY KEY(id)
8    );
9       
10       DELIMITER $$
11       CREATE TRIGGER display_students
12AFTER INSERT
13on students FOR EACH ROW
14BEGIN
15IF mesatarja < 6 THEN
16INSERT INTO students(mesazhi)
17VALUES(concat('mesatarja jote eshte me e vogel se mesatarja e pranueshme 6'));
18elseif mesatarja> 6 THEN
19INSERT INTO students(mesazhi)
20VALUES(concat('ju lumte,mesatarja jote eshte me e madhe se mesatarja e pranueshme 6'));
21END IF;
22END$$
23DELIMITER ;