sql - Mysql How to insert all updated old and new rows by using trigger

Question

I am creating a log table by using trigger in mysql

I want to insert only updated old value, new value and row name to the log_table when the specific target_table id is update.

target_table

id	row1	row2	row3	row4	row5	row6
One	item	item	item	item	item	item

Answer 1

等待大神答复