BEFORE INSERT ON `question`
FOR EACH ROW
BEGIN
DECLARE aut INT;
DECLARE que TEXT;
DECLARE adr INT;
DECLARE user INT;
//this thing made me think for 5 hours
SELECT author, adressed_user,text
INTO aut, adr, mess
FROM question
WHERE aut != adr;
SET que=mess;
INSERT INTO notification(`user`,`message`,`from`,`notification_type`) values (user,que,aut,1);
END$$
delimiter ;
guys if you can help with this problem it would be awesome
thank you
can you tell me my errors?
???
Обсуждают сегодня