title: Insert into same table trigger mysql
body: <p>I need to insert a discount line into a table everything time a I insert a line into the same table.
  Now i know that this could end in a endless loop but I have put checks in so it wont insert anything when the discount line is inserted.</p>
  
  <p>Mysql doesnt seem to allow this.It doesnt even insert into the table let alone fire off the trigger</p>
  
  <p>Any suggestions on how to do this?</p>