Re: Trigger is running equal to times, the no of columns updated in the row

[Peter Brawley]

The Trigger sets v_sequence_no to 1+ the biggest such value it can find, so if another user is writing a history record at the same time, you will get duplicates. To prevent this, use auto_increment.

Then for each of several column names, the Trigger sets v_column_name, v_column_value_new and v_column_value_old, each trio of SETs overwriting the last, so by the time the insert happens, your v_column_... variables hold just the last trio of such assignments.

BTW, names in caps are much harder to read than lower case.