title: SQL Insert from Select to same table but with a changed ID - MySQL
body: <p>I need to copy a number of rows from a table that have the same id_shop value, then insert these rows back into the same table but with a different id_shop value. I'm not sure how to do the later part. I'm guessing that it will be a variation of the following.</p>
  
  <pre><code>  INSERT INTO `ps_hook_module`(`id_module`, `id_shop`, `id_hook`, `position`)
    SELECT `id_module`, `id_shop`, `id_hook`, `position` FROM `ps_hook_module` WHERE     
    `id_shop` = 1
  </code></pre>