Because the database data is very large, many fields, how can I write a summary service export I will field, and then to another table, I built great god to give me answer

CodePudding user response:

1. Create your summary table
2. Write a stored procedure, including your business logic, and probably the following syntax:

Insert into the summary table (c1 and c2,,,)
Select sum (),,,
The from list
Group by,,,

3. Create a job, execute the stored procedure regularly, write data to the summary,