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
ie:
TALBE_B (New Table Updated as TABLE_A data changes) (using CREATE TRIGGER..? )
Any help would be greatly appreciated!!!
UPDATE
statement you would use if you had to do it manually. Then modify that into aINSERT ... ON DUPLICATE KEY UPDATE
that will take care of either inserting or updating, and let's see that.