title: How to insert row in table with foreign key to itself?
body: <p>I have <a href="https://picasaweb.google.com/TheAteist/ERD?authkey=Gv1sRgCMapkN6EzLa6Mg#5609625343557306466" rel="noreferrer">table</a> that has foreign key for itself. Column <strong>parentid</strong> is foreign key and it <strong>cannot</strong> be NULL.</p>
  
  <p>if I do<code>INSERT INTO mytable(name) VALUES('name')</code>, so it says that can't insert NULL to <strong>parentid</strong>. BUT, what value I can set to it if no row was inserted yet?!</p>
  
  <p>How I can write script that will add row to this table?</p>
  
  <p>Thank you</p>