title: MySQL trigger to copy all field values to another table, how?
body: <p>I have 2 identical table (100% identical), </p>
  
  <pre><code>DELIMITER $$
  
  CREATE
  /*[DEFINER = { user | CURRENT_USER }]*/
  TRIGGER `db`.`new_user` AFTER INSERT
  ON `db`.`user`
  FOR EACH ROW BEGIN
  INSERT INTO db2.`users` COPY ALL INSERTED DATA
  END$$
  
  DELIMITER ;
  </code></pre>
  
  <p>How should the INSER query look like? Do I have to specifiy all field names one by one?</p>