title: jOOQ insert query with returning generated keys
body: <p>I installed jOOQ into eclipse, generated classes for my mySQL, but I still have problems to  write also some basic queries.</p>
  
  <p>I tried to compose insert query with returning of generated keys, but compiler throws error </p>
  
  <p>Table: tblCategory
  Columns:  category_id, parent_id, name, rem, uipos</p>
  
  <pre><code>Result&lt;TblcategoryRecord&gt; result= create.insertInto(Tblcategory.TBLCATEGORY, 
      Tblcategory.PARENT_ID, Tblcategory.NAME, Tblcategory.REM, Tblcategory.UIPOS)
          .values(node.getParentid())
          .values(node.getName())
          .values(node.getRem())
          .values(node.getUipos())
          .returning(Tblcategory.CATEGORY_ID)
          .fetch();
  </code></pre>
  
  <p>tried also other differnt ways 
  how to do it right way?</p>
  
  <p>thanks
  charis</p>