8qKzJtnU

1DROP TABLE IF EXISTS anetar;
2CREATE TABLE anetar (
3    id int AUTO_INCREMENT,
4    emri varchar(100) NOT NULL,
5    emaili varchar(100),
6    ditelindja date ,
7    PRIMARY KEY(id)
8    );
9    DROP TABLE IF EXISTS kujtese;
10    CREATE TABLE  kujtese(
11        id int AUTO_INCREMENT,
12        anetarId int,
13        message varchar(255) NOT NULL,
14        PRIMARY KEY (id , anetarId)
15       );
16       
17       DELIMITER $$
18       CREATE TRIGGER after_anetar_insert
19
20AFTER INSERT 
21on anetar FOR EACH ROW
22BEGIN
23IF new.ditelindja IS NULL THEN
24INSERT INTO kujtese(anetarId , message)
25VALUES(new.id ,concat('pershendetje',new.emri , 'Ju lutemi update ditelindjen'));
26END IF;
27END$$ DELIMITER ;
28INSERT INTO anetar (emri,emaili, ditelindja)
29VALUES('johan doe','johan.doe@examole.com',NULL);