title: Possible to do insert into select in jpa using mysql?
body: <p>I am trying to make a simple backup of data into a history table at the end of each day.</p>
  
  <p>But it seems to fail to execute as it should. It will not generate an error. But it will also not do the insert as exepected. It will run clean through using Mysql workbench.</p>
  
  <pre><code>query = em.createNativeQuery("insert into sgdatatest.ASSETHISTORY select * from sgdatatest.ASSET where dayssinceepoch &lt;= :dayssinceepoch");
          query.setParameter("daysSinceEpoch", daysSinceEpoch);
          query.executeUpdate();
  </code></pre>