title: Update table in a trigger with values from stored procedure
body: <p>I wanted to make a trigger which updates a table with the values of a procedure. I want the trigger to do something like this:</p>
  
  <pre><code>DELIMITER $$
  CREATE TRIGGER onInsertVillage AFTER INSERT ON Village
  FOR EACH ROW
  BEGIN
      UPDATE Village V SET V.xCoordinaat = x, V.yCoordinaat = y FROM getVrijePlaatsInMap();
  END$$
  DELIMITER ;
  </code></pre>
  
  <p>But this doesn't work.. The procedure returns an x and y value by the way. Is there a possible way to make the trigger do it's job?</p>