CREATE TABLE `table1` (

  `id` int(11) NOT NULL,

  `name` varchar(20) DEFAULT NULL,

  `lastedatet` datetime NOT NULL INVISIBLE DEFAULT current_timestamp()

) ENGINE=InnoDB;

insert into table1 (id,name) values (1,'andre');

CREATE TABLE `table2` (

  `id` int(11) NOT NULL,

  `name` varchar(20) DEFAULT NULL,

  `lastedatet` datetime NOT NULL INVISIBLE DEFAULT current_timestamp() ON UPDATE current_timestamp()

) ENGINE=InnoDB;

insert into table2 (id,name) values (1,'andre');

[root@m1 ~]# mysqldump andre table1 | grep INSERT

INSERT INTO `table1` (`id`, `name`, `lastedatet`) VALUES (1,'andre','2022-04-07 10:33:01');

[root@m1 ~]# mysqldump andre table2 | grep INSERT

INSERT INTO `table2` VALUES (1,'andre','2022-04-07 10:33:36');

INSERT INTO `table2` VALUES (1,'andre','2022-04-07 10:33:36');

ERROR 1136 (21S01): Column count doesn't match value count at row 1