title: Trigger created successfully but its not working as it should
body: <p>I have created this trigger that inserts a record into another table once a record has been inserted in another table</p>
  
  <pre><code>DELIMITER $$
  CREATE TRIGGER logan AFTER INSERT ON messagein
  FOR EACH ROW
    BEGIN
    DECLARE le_number INT;
    SET le_number = (select messagefrom from messagein where id=NEW.id);
      insert into messageout (MessageTo,MessageText) VALUES(le_number,"Thank you for contacting our company.Our sales representatives shall be in touch with you soon.");
    END $$
  DELIMITER ;
  </code></pre>
  
  <p>This trigger is created successfully but no message is inserted into the <code>messageout</code> table.What is the reason for this?.</p>