title: Copy entire row from one table to another in MYSQL trigger
body: <p>I have two tables with identical schemas, I want to copy the newly inserted record from table1 to table2 in a trigger, my code is below and works, but only copies the id field</p>
  
  <pre><code>BEGIN
     insert into Table2 (id) values (new.id);
  END
  </code></pre>
  
  <p>However the table many columns, is there a way to copy the entire record into the table2 without specifying all the columns and values, like below</p>
  
  <pre><code>BEGIN
     insert into Table2 SELECT * FROM NEW;
  END
  </code></pre>
  
  <p>Thanks</p>