title: how can i add data from table 1 to table 2 in mysql?
body: <p>lately I've been getting into mysql a bit, i have 2 tables and i want to do the following:</p>
  
  <p>Table 1:<br>
  | ID | Code | Merk |                        </p>
  
  <p>Table 2:</p>
  
  <p>| ID | Code | Merken |</p>
  
  <p>My table 2 is filled with data, and has one column named 'Merken'. For now the column is filled with NULLs. Table 2 has a column named 'Code', this column contains lots of codes with characters and integers, I've made them varchars.
  My Table 1 is also filled with data, and has a column named 'Merk'.</p>
  
  <p>Now what i want to do is the following:</p>
  
  <p>How can i make it so that when i compare the Code colums from both the tables that I insert a 'Merk' from table 1 into the 'Merken' column from table 2 when the code is a match? How should i structure my sql query with an insert statement?</p>