Unanswered: Updating one table after insert in another table
I have been having a hard time figuring out how to make 'table2' update its values based on the values in 'table1' whenever new rows are inserted in 'table1'. I insert a couple thousand rows into 'table1' at a time using 'load data infile' and text files. If possible I would like the update on table 2 to occur after the entire file is inserted in to 'table1', not after each row is inserted. Any help would be greatly appreciated. Below I have included the definition from table1 and what I need in table2.