例如:
show create table t\G
1. row **
Table: t
Create Table: CREATE TABLE t
(
id
int(11) DEFAULT NULL,
name
varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
MariaDB [test]> alter table t change id id int(20);
Query OK, 0 rows affected (0.29 sec)
Records: 0 Duplicates: 0 Warnings: 0
MariaDB [test]> show create table t\G
1. row **
Table: t
Create Table: CREATE TABLE t
(
id
int(20) DEFAULT NULL,
name
varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
1 row in set (0.00 sec)
怎么把int(20)自动改回来的int(11)?