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?
                  
                  
                
???
Обсуждают сегодня