How does MySQL reindex a table?

How can I copy mysql cell info from one table into another?

• I have two tables belowmwhich explains what im trying to do. I want the second table to automatically pull info from the first table. I want to avoid the method of sending queries to both tables via php etc. Comment userid name comment 1111 chris I like stuff 1112 tim this is me 1113 tom my comment here 1114 mel lalalalala 1115 chloe im chloe 1116 bob blah 1117 jim blahblah 1118 dave biopbio 1119 claire whoop 1120 sally ding Employee table for user id 3456 user id comment 1111 "insert comment from table name 'comment' where id is the same" 1112 "insert comment from table name 'comment' where id is the same" 1113 "insert comment from table name 'comment' where id is the same" 1114 "insert comment from table name 'comment' where id is the same" 1115 "insert comment from table name 'comment' where id is the same"

• Answer:

  Google search mySQL triggers for your answer