MyIsam DB
To be specific, I insert into one table 5-10 rows at the time usually. After inserts are done, I want to get COUNT(DISTINCT(column)) and SUM(some_other_column) of the newly inserted rows and insert it into another table.
How I figured this might be done (but I don't know if it can) is to make a trigger on after insert and then make one select on table where I inserted the rows, insert it into another table and break trigger's for loop.
Suggestions please. I feel bad about this somehow.