To help write A mysql stored procedures, demands the following A: enter the name of the table, set up corresponding side tables, one side tables to have additional record primary key (ID_ROW_SEQ_NO) from growth, additional fields, update time (LG_CHG_TIME), tag, operation records, source system
Ask B: set up the table name, set up the trigger changes with increasing deletion function will capture data to corresponding side tables, the main table to add a record, add a record, the side tables marked "I", the main table to delete a record, add a record, the side tables marked "D", the main table to update a record, add a record, the side tables marked "U"
C: operating table trigger B table