title: Copy rows and change 1 value?
body: <p>How would I copy entire rows within a table and change one value?</p>
  
  <pre><code> insert into user (
       user_id,account_id,user_type_cd,name,e_mail_addr,
       login_failure_cnt,admin_user,primary_user
   )
   select * from pnet_user where account_id='1'
  </code></pre>
  
  <p>But now I want to change 1 to 2 on the inserted entries. 
  But now I want to change 1 to 3 on the inserted entries. 
  But now I want to change 1 to .... on the inserted entries. 
  But now I want to change 1 to 1000 on the inserted entries. </p>
  
  <p>It will copy and write down 1000 times (only changing id ). </p>