mysql> CREATE TABLE IF NOT EXISTS `test` (
    ->   `time` TIMESTAMP(0) NOT NULL,
    ->   `code` STRING NULL,
    ->   `name` STRING NULL,
    ->   `status` TINYINT NULL,
    ->   TIME INDEX (`time`),
    ->   PRIMARY KEY (`code`)
    -> ) ENGINE=mito WITH(
    ->   append_mode = 'false',
    ->   merge_mode = 'last_non_null'
    -> );
Query OK, 0 rows affected (0.19 sec)

mysql>
mysql> INSERT INTO `test` (`time`, `code`, `name`, `status`) VALUES ('2024-11-26 10:00:00', 'achn', '1.png', 0);
Query OK, 1 row affected (0.03 sec)

mysql> INSERT INTO `test` (`time`, `code`, `name`, `status`) VALUES ('2024-11-26 10:01:00', 'achn', '2.png', 0);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO `test` (`time`, `code`, `name`, `status`) VALUES ('2024-11-26 10:02:00', 'achn', '3.png', 1);
Query OK, 1 row affected (0.00 sec)

mysql>
mysql> SELECT * FROM `test`;
+---------------------+------+-------+--------+
| time                | code | name  | status |
+---------------------+------+-------+--------+
| 2024-11-26 10:00:00 | achn | 1.png |      0 |
| 2024-11-26 10:01:00 | achn | 2.png |      0 |
| 2024-11-26 10:02:00 | achn | 3.png |      1 |
+---------------------+------+-------+--------+
3 rows in set (0.15 sec)

mysql> DELETE FROM `test`;

mysql>
mysql> INSERT INTO `test` (`time`, `code`, `name`) VALUES ('2024-11-26 10:00:00', 'achn', '1.png');
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO `test` (`time`, `code`, `name`) VALUES ('2024-11-26 10:01:00', 'achn', '2.png');
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO `test` (`time`, `code`, `name`) VALUES ('2024-11-26 10:02:00', 'achn', '3.png');
Query OK, 1 row affected (0.00 sec)

mysql>
mysql> SELECT * FROM `test`;
+---------------------+------+-------+--------+
| time                | code | name  | status |
+---------------------+------+-------+--------+
| 2024-11-26 10:00:00 | achn | 1.png |      0 |
| 2024-11-26 10:01:00 | achn | 2.png |      0 |
| 2024-11-26 10:02:00 | achn | 3.png |      1 |
+---------------------+------+-------+--------+
3 rows in set (0.02 sec)