title: MySql Error: Can't update table in stored function/trigger because it is already used by statement which invoked this stored function/trigger
body: <p>I am running a MySQL Query. But when a new row is added from form input I get this error:</p>
  
  <pre><code>Error: Can't update table 'brandnames' in stored function/trigger because it is 
  already used by statement which invoked this stored function/trigger.
  </code></pre>
  
  <p>From the code:</p>
  
  <pre><code>CREATE TRIGGER `capital` AFTER INSERT ON `brandnames`
  FOR EACH
  ROW UPDATE brandnames
  SET bname = CONCAT( UCASE( LEFT( bname, 1 ) ) , LCASE( SUBSTRING( bname, 2 ) ) )
  </code></pre>
  
  <p>What does this error mean?</p>