title: Can't create a TRIGGER from within another stored routine -- What is another "stored routine"?
body: <p>I'm trying to create a trigger in MySQL using PhpMyAdmin.</p>
  
  <pre><code>CREATE TRIGGER Update_Last_Transit_Status AFTER INSERT ON Delivery 
  FOR EACH ROW
  BEGIN
  UPDATE Transportation SET Status="Dispatched" WHERE 
  EXISTS (SELECT * FROM Transit, Route WHERE Transit.ID=Route.Transit_ID and
          Route.Delivery_ID=Delivery.ID and 
          Transit.Transportation_ID=Transportation.ID) and
          Status="In Branch"
  END
  </code></pre>
  
  <p>It says:</p>
  
  <pre><code>MySQL said: #1303 - Can't create a TRIGGER from within another stored routine
  </code></pre>
  
  <p>I know this error has been addressed before, but this wasn't my intention at all.</p>
  
  <p>Where is "another stored routine" here?</p>
  
  <p>I don't intend to what the error message says.</p>
  
  <p><strong>EDIT:</strong>
  There are no other triggers defined. There is however one procedure predefined:</p>
  
  <pre><code>begin
          select user() as first_col;
          select user() as first_col, now() as second_col;
          select user() as first_col, now() as second_col, now() as third_col;
          end
  </code></pre>
  
  <p>I don't know what it does, or why it is there, but it was there before.</p>