事情是因为一次同步的时候,需求需要目标端表需要增加插入更新时间字段
源表
mysql> create table test_all(name varchar(20),age int);
Query OK, 0 rows affected (0.03 sec)
mysql> desc
test_all;
+-------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| name | varchar(20) | YES | | NULL | |
| age | int(11) | YES | | NULL | |
+-------+-------------+------+-----+---------+-------+
2 rows in set (0.00 sec)
mysql> insert into test_all values('aass',12);
Query OK, 1 row affected (0.00 sec)
mysql> insert into test_all values('dfa',22);
Query OK, 1 row affected (0.00 sec)
mysql> commit;
Query OK, 0 rows affected (0.00 sec)
目标表