Mysql trigger a table is recorded in table B

1: Query out the required column names for backup

#列名
Select column_name from Information_schema.columns
where table_schema= ' yunpiaobox_db ' and table_name= ' T_box_status '

TABLE_SCHEMA: Database name table_name: Table name

#列名字符串 Press, separate
Select
Group_concat (column_name separator ', ') ' comma separated ',
Group_concat (CONCAT (' new ', column_name) separator ', ') ' new ' field comma separated ',
Group_concat (CONCAT (column_name, ' =new. ', column_name) ' separator ', ') ' field =new. Field Comma separated '
From Information_schema.columns
where table_schema= ' yunpiaobox_db ' and table_name= ' T_box_status '

2: Tool Navicat Premium Right-click a table---> Design table---> select trigger

Mysql trigger a table is recorded in table B