Похожие чаты

DROP TRIGGER IF EXISTS notification_; delimiter $$ CREATE TRIGGER `notification_`

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?

2 ответов

14 просмотров
Ilyos Olimov- Автор вопроса
Ilyos Olimov- Автор вопроса

???

Похожие вопросы

Карта сайта