title: Insert statement in self-join table
body: <p>What is the correct statement to make an insert in a table with a self-join?</p>
  
  <p>If I try to make a classic insert I get the error:</p>
  
  <blockquote>
    <p>Cannot add or update a child row: a foreign key constraint fails</p>
  </blockquote>
  
  <p>This is my insert query:</p>
  
  <pre><code>insert into mTable(record_name,self_fk,val, note, ref,insert_date, end_date)
      values('processo prova',0,1,'nota di prova', 'az12345', NOW(), NOW());
  </code></pre>