MariaDB [test]> create table t (a int);
|
Query OK, 0 rows affected (0.214 sec)
|
|
MariaDB [test]> alter table t change column if exists a b int;
|
Query OK, 0 rows affected (0.044 sec)
|
Records: 0 Duplicates: 0 Warnings: 0
|
|
MariaDB [test]> alter table t modify column if exists b char(8);
|
Query OK, 0 rows affected (0.292 sec)
|
Records: 0 Duplicates: 0 Warnings: 0
|
|
MariaDB [test]> alter table t add column if not exists a int;
|
Query OK, 0 rows affected (0.040 sec)
|
Records: 0 Duplicates: 0 Warnings: 0
|
|
MariaDB [test]> alter table t drop column if exists a;
|
Query OK, 0 rows affected (0.089 sec)
|
Records: 0 Duplicates: 0 Warnings: 0
|