title: MySQL copying a column from another table
body: <p>Hello so I have two tables and I want to copy one column from table1 to table2.</p>
  
  <pre><code>SET @m=0;
  SELECT column INTO @m FROM table1;
  UPDATE table2 SET column = @m;
  </code></pre>
  
  <p>Basically I tried to insert into the column in table2 the values from column in table1. What am I doing wrong?</p>
  
  <p>LE: I tried the INSERT INTO and it worked in the end but it inserted the values after my desired rows. Basically all my rows had the values 0 and it created another set of rows with the correct values.</p>