title: Copy from one column to another (different tables same database) mysql
body: <p>Hi I would like to copy entire contents from column Item under table IName to column Name under table Item both belonging to the same database.</p>
  
  <p>I am giving the following query but it throws the error saying that the subquery returned more than one records. (There are around 600 records) </p>
  
  <pre><code>Insert into Item set name = (Select Item from IName)
  </code></pre>
  
  <p>Thanks</p>