[root@server04 ~]# mysql Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 9 Server version: 10.7.3-MariaDB-log MariaDB Server Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. root@localhost [(none)] 15:09:44> use db1; Database changed root@localhost [db1] 15:09:59> root@localhost [db1] 15:10:18> root@localhost [db1] 15:10:18> SHOW GLOBAL VARIABLES LIKE 'mysql5%'; +-------------------------+-------+ | Variable_name | Value | +-------------------------+-------+ | mysql56_temporal_format | ON | +-------------------------+-------+ 1 row in set (0.001 sec) root@localhost [db1] 15:10:19> show global variables like 'innodb_default_row_format'; +---------------------------+---------+ | Variable_name | Value | +---------------------------+---------+ | innodb_default_row_format | dynamic | +---------------------------+---------+ 1 row in set (0.001 sec) root@localhost [db1] 15:10:32> set global mysql56_temporal_format=OFF; Query OK, 0 rows affected (0.000 sec) root@localhost [db1] 15:10:42> root@localhost [db1] 15:10:43> CREATE TABLE `tab1` ( -> `SERVICE_ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '서비스ID', -> `SEND_TS` datetime(6) DEFAULT NULL COMMENT '전송타임스탬프', -> PRIMARY KEY (`SERVICE_ID`) -> ) ENGINE=InnoDB AUTO_INCREMENT=8912746 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='인포뱅크전송' -> ; Query OK, 0 rows affected (0.146 sec) root@localhost [db1] 15:10:50> root@localhost [db1] 15:10:51> show create table tab1; +-------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +-------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | tab1 | CREATE TABLE `tab1` ( `SERVICE_ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '서비스ID', `SEND_TS` datetime(6) /* mariadb-5.3 */ DEFAULT NULL COMMENT '전송타임스탬프', PRIMARY KEY (`SERVICE_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=8912746 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci COMMENT='인포뱅크전송' | +-------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.007 sec) root@localhost [db1] 15:11:02> insert into tab1 (send_ts) values (now()); Query OK, 1 row affected (0.061 sec) root@localhost [db1] 15:11:52> select * from tab1; +------------+----------------------------+ | SERVICE_ID | SEND_TS | +------------+----------------------------+ | 8912746 | 2022-04-07 15:11:47.000000 | +------------+----------------------------+ 1 row in set (0.000 sec) root@localhost [db1] 15:11:59> root@localhost [db1] 15:12:10> set global mysql56_temporal_format=ON; Query OK, 0 rows affected (0.000 sec) root@localhost [db1] 15:12:18> SET SESSION alter_algorithm='INSTANT'; Query OK, 0 rows affected (0.000 sec) root@localhost [db1] 15:12:25> ALTER TABLE tab1 MODIFY `SEND_TS` datetime(6) DEFAULT NULL COMMENT '전송타임스탬프'; ERROR 1846 (0A000): ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY