1# INPLACE ALTER WITH INPLACE_IGNORE FLAG AND CHANGE CREATE OPTION
2# CHANGE THE COLUMN DEFAULT (INPLACE_IGNORE)
3# AND TABLE CHARSET(CHANGE CREATE)
4CREATE TABLE t1(
5id INT PRIMARY KEY,
6f1 INT NOT NULL DEFAULT 0)ENGINE=INNODB;
7INSERT INTO t1 VALUES(1, 2);
8SET SQL_MODE='STRICT_ALL_TABLES';
9ALTER TABLE t1 MODIFY COLUMN f1 INT NOT NULL DEFAULT 0,
10DEFAULT CHARSET=latin1, ALGORITHM=INPLACE;
11DROP TABLE t1;
12# CHANGE THE COMMENT OF COLUMN(INPLACE IGNORE)
13# AND TABLE CHARSET(CHANGE CREATE)
14CREATE TABLE t1(id INT COMMENT 'independence day')ENGINE=INNODB;
15INSERT INTO t1 values(1);
16ALTER TABLE t1 MODIFY COLUMN id INT COMMENT 'identifier',
17DEFAULT CHARSET=latin1, ALGORITHM=INPLACE;
18DROP TABLE t1;
19# RENAME THE TABLE(INPLACE IGNORE)
20# AND CHANGE TABLE CHARSET(CHANGE CREATE)
21CREATE TABLE t1(
22f1 INT NOT NULL,
23f2 INT NOT NULL)ENGINE=INNODB;
24INSERT INTO t1 VALUES(1, 2);
25ALTER TABLE t1 RENAME t2, DEFAULT CHARSET=latin1, ALGORITHM=INPLACE;
26DROP TABLE t2;
27