title: Can i run an application(or stored procedure) and get result from trigger
body: <p>I want to create a trigger on table1 that inserts/updates table2. </p>
  
  <pre><code>DELIMITER $$
  CREATE TRIGGER after_table1_update 
  after UPDATE ON table1
  BEGIN
  FOR EACH ROW 
   Insert into table2
   SET password = OLD.password,
      name = OLD.name; 
  END$$
  DELIMITER ;
  </code></pre>
  
  <p>The problem here is that I want to first decrypt (old.password) and then hash it before inserting into the second table. I have a c# program that does it but how can i do it here?</p>