title: inserting another row in mysql database with values similar to previous row
body: <p>I have a table like,</p>
  
  <pre><code>BatchID Volume1 Volume2 Volume3
  
  1        3.0      4.0     5.0
  1        2.0      1.0     2.0
  2        1.0      2.0     4.0 
  2        1.0      1.0     1.0
  2        1.0      1.0     1.0
  </code></pre>
  
  <p>I am trying to add another batchid 3 with same volume1, volume2 and volume3 values
  such that it looks like (same records from batchID 2)</p>
  
  <pre><code>1        3.0      4.0     5.0
  1        2.0      1.0     2.0
  2        1.0      2.0     4.0 
  2        1.0      1.0     1.0
  2        1.0      1.0     1.0
  3        1.0      2.0     4.0 
  3        1.0      1.0     1.0
  3        1.0      1.0     1.0
  </code></pre>
  
  <p>I wrote the following query </p>
  
  <pre><code>insert into table1 (BatchID,Volume1,Volume2,Volume3) Values 
  (`3`,Select Volume1,Volume2,Volume3 from table1 where batchid = '2')
  </code></pre>
  
  <p>gives an error. </p>
  
  <p>P.S I know the above is not a good database design. This is over simplified version of my actual design. </p>