I have a TABLE_A in Database1 the contains rows with a common group id. I am wanting to use the CREATE TRIGGER function to generate a new TABLE_B in the same Database1 that contains calculated values (summed/multipled ect.) of certain columns with the same group id. and to group these all together. Using Mysql 5.5
TALBE_B (New Table Updated as TABLE_A data changes) (using CREATE TRIGGER..? )
Any help would be greatly appreciated!!!