EVOLUTION-MANAGER

Edit File: ta_add_string_first2.result

DROP TABLE IF EXISTS t5; CREATE TABLE t5(c1 BIT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` bit(1) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 CHAR(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` char(5) DEFAULT NULL, `c1` bit(1) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 TINYINT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` tinyint(4) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 CHAR(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` char(5) DEFAULT NULL, `c1` tinyint(4) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 SMALLINT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` smallint(6) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 CHAR(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` char(5) DEFAULT NULL, `c1` smallint(6) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 MEDIUMINT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` mediumint(9) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 CHAR(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` char(5) DEFAULT NULL, `c1` mediumint(9) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 INT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` int(11) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 CHAR(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` char(5) DEFAULT NULL, `c1` int(11) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 INTEGER NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` int(11) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 CHAR(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` char(5) DEFAULT NULL, `c1` int(11) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 BIGINT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` bigint(20) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 CHAR(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` char(5) DEFAULT NULL, `c1` bigint(20) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 REAL NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` double DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 CHAR(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` char(5) DEFAULT NULL, `c1` double DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 DOUBLE NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` double DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 CHAR(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` char(5) DEFAULT NULL, `c1` double DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 FLOAT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` float DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 CHAR(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` char(5) DEFAULT NULL, `c1` float DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 DECIMAL NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` decimal(10,0) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 CHAR(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` char(5) DEFAULT NULL, `c1` decimal(10,0) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 NUMERIC NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` decimal(10,0) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 CHAR(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` char(5) DEFAULT NULL, `c1` decimal(10,0) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 DATE NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` date DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 CHAR(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` char(5) DEFAULT NULL, `c1` date DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 TIME NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` time DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 CHAR(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` char(5) DEFAULT NULL, `c1` time DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 TIMESTAMP NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` timestamp NULL DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 CHAR(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` char(5) DEFAULT NULL, `c1` timestamp NULL DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 YEAR NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` year(4) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 CHAR(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` char(5) DEFAULT NULL, `c1` year(4) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 TINYBLOB NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` tinyblob DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 CHAR(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` char(5) DEFAULT NULL, `c1` tinyblob DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 BLOB NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` blob DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 CHAR(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` char(5) DEFAULT NULL, `c1` blob DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 MEDIUMBLOB NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` mediumblob DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 CHAR(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` char(5) DEFAULT NULL, `c1` mediumblob DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 LONGBLOB NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` longblob DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 CHAR(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` char(5) DEFAULT NULL, `c1` longblob DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 TINYTEXT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` tinytext DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 CHAR(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` char(5) DEFAULT NULL, `c1` tinytext DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 TEXT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` text DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 CHAR(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` char(5) DEFAULT NULL, `c1` text DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 MEDIUMTEXT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` mediumtext DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 CHAR(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` char(5) DEFAULT NULL, `c1` mediumtext DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 LONGTEXT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` longtext DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 CHAR(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` char(5) DEFAULT NULL, `c1` longtext DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 BIT NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` bit(1) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` char(5) NOT NULL, `c1` bit(1) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 TINYINT NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` tinyint(4) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` char(5) NOT NULL, `c1` tinyint(4) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 SMALLINT NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` smallint(6) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` char(5) NOT NULL, `c1` smallint(6) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 MEDIUMINT NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` mediumint(9) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` char(5) NOT NULL, `c1` mediumint(9) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 INT NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` int(11) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` char(5) NOT NULL, `c1` int(11) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 INTEGER NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` int(11) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` char(5) NOT NULL, `c1` int(11) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 BIGINT NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` bigint(20) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` char(5) NOT NULL, `c1` bigint(20) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 REAL NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` double NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` char(5) NOT NULL, `c1` double NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 DOUBLE NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` double NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` char(5) NOT NULL, `c1` double NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 FLOAT NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` float NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` char(5) NOT NULL, `c1` float NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 DECIMAL NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` decimal(10,0) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` char(5) NOT NULL, `c1` decimal(10,0) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 NUMERIC NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` decimal(10,0) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` char(5) NOT NULL, `c1` decimal(10,0) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 DATE NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` date NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` char(5) NOT NULL, `c1` date NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 TIME NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` time NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` char(5) NOT NULL, `c1` time NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 TIMESTAMP NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` char(5) NOT NULL, `c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 YEAR NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` year(4) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` char(5) NOT NULL, `c1` year(4) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 TINYBLOB NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` tinyblob NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` char(5) NOT NULL, `c1` tinyblob NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 BLOB NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` blob NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` char(5) NOT NULL, `c1` blob NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 MEDIUMBLOB NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` mediumblob NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` char(5) NOT NULL, `c1` mediumblob NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 LONGBLOB NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` longblob NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` char(5) NOT NULL, `c1` longblob NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 TINYTEXT NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` tinytext NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` char(5) NOT NULL, `c1` tinytext NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 TEXT NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` text NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` char(5) NOT NULL, `c1` text NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 MEDIUMTEXT NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` mediumtext NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` char(5) NOT NULL, `c1` mediumtext NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 LONGTEXT NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` longtext NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 CHAR(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` char(5) NOT NULL, `c1` longtext NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 BIT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` bit(1) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varchar(5) DEFAULT NULL, `c1` bit(1) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 TINYINT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` tinyint(4) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varchar(5) DEFAULT NULL, `c1` tinyint(4) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 SMALLINT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` smallint(6) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varchar(5) DEFAULT NULL, `c1` smallint(6) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 MEDIUMINT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` mediumint(9) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varchar(5) DEFAULT NULL, `c1` mediumint(9) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 INT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` int(11) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varchar(5) DEFAULT NULL, `c1` int(11) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 INTEGER NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` int(11) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varchar(5) DEFAULT NULL, `c1` int(11) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 BIGINT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` bigint(20) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varchar(5) DEFAULT NULL, `c1` bigint(20) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 REAL NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` double DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varchar(5) DEFAULT NULL, `c1` double DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 DOUBLE NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` double DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varchar(5) DEFAULT NULL, `c1` double DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 FLOAT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` float DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varchar(5) DEFAULT NULL, `c1` float DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 DECIMAL NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` decimal(10,0) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varchar(5) DEFAULT NULL, `c1` decimal(10,0) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 NUMERIC NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` decimal(10,0) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varchar(5) DEFAULT NULL, `c1` decimal(10,0) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 DATE NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` date DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varchar(5) DEFAULT NULL, `c1` date DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 TIME NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` time DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varchar(5) DEFAULT NULL, `c1` time DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 TIMESTAMP NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` timestamp NULL DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varchar(5) DEFAULT NULL, `c1` timestamp NULL DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 YEAR NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` year(4) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varchar(5) DEFAULT NULL, `c1` year(4) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 TINYBLOB NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` tinyblob DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varchar(5) DEFAULT NULL, `c1` tinyblob DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 BLOB NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` blob DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varchar(5) DEFAULT NULL, `c1` blob DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 MEDIUMBLOB NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` mediumblob DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varchar(5) DEFAULT NULL, `c1` mediumblob DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 LONGBLOB NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` longblob DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varchar(5) DEFAULT NULL, `c1` longblob DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 TINYTEXT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` tinytext DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varchar(5) DEFAULT NULL, `c1` tinytext DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 TEXT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` text DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varchar(5) DEFAULT NULL, `c1` text DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 MEDIUMTEXT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` mediumtext DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varchar(5) DEFAULT NULL, `c1` mediumtext DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 LONGTEXT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` longtext DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varchar(5) DEFAULT NULL, `c1` longtext DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 BIT NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` bit(1) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varchar(5) NOT NULL, `c1` bit(1) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 TINYINT NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` tinyint(4) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varchar(5) NOT NULL, `c1` tinyint(4) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 SMALLINT NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` smallint(6) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varchar(5) NOT NULL, `c1` smallint(6) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 MEDIUMINT NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` mediumint(9) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varchar(5) NOT NULL, `c1` mediumint(9) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 INT NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` int(11) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varchar(5) NOT NULL, `c1` int(11) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 INTEGER NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` int(11) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varchar(5) NOT NULL, `c1` int(11) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 BIGINT NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` bigint(20) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varchar(5) NOT NULL, `c1` bigint(20) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 REAL NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` double NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varchar(5) NOT NULL, `c1` double NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 DOUBLE NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` double NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varchar(5) NOT NULL, `c1` double NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 FLOAT NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` float NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varchar(5) NOT NULL, `c1` float NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 DECIMAL NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` decimal(10,0) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varchar(5) NOT NULL, `c1` decimal(10,0) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 NUMERIC NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` decimal(10,0) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varchar(5) NOT NULL, `c1` decimal(10,0) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 DATE NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` date NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varchar(5) NOT NULL, `c1` date NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 TIME NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` time NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varchar(5) NOT NULL, `c1` time NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 TIMESTAMP NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varchar(5) NOT NULL, `c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 YEAR NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` year(4) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varchar(5) NOT NULL, `c1` year(4) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 TINYBLOB NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` tinyblob NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varchar(5) NOT NULL, `c1` tinyblob NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 BLOB NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` blob NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varchar(5) NOT NULL, `c1` blob NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 MEDIUMBLOB NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` mediumblob NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varchar(5) NOT NULL, `c1` mediumblob NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 LONGBLOB NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` longblob NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varchar(5) NOT NULL, `c1` longblob NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 TINYTEXT NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` tinytext NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varchar(5) NOT NULL, `c1` tinytext NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 TEXT NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` text NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varchar(5) NOT NULL, `c1` text NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 MEDIUMTEXT NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` mediumtext NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varchar(5) NOT NULL, `c1` mediumtext NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 LONGTEXT NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` longtext NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARCHAR(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varchar(5) NOT NULL, `c1` longtext NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 BIT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` bit(1) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 BINARY(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` binary(5) DEFAULT NULL, `c1` bit(1) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 TINYINT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` tinyint(4) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 BINARY(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` binary(5) DEFAULT NULL, `c1` tinyint(4) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 SMALLINT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` smallint(6) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 BINARY(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` binary(5) DEFAULT NULL, `c1` smallint(6) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 MEDIUMINT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` mediumint(9) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 BINARY(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` binary(5) DEFAULT NULL, `c1` mediumint(9) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 INT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` int(11) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 BINARY(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` binary(5) DEFAULT NULL, `c1` int(11) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 INTEGER NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` int(11) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 BINARY(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` binary(5) DEFAULT NULL, `c1` int(11) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 BIGINT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` bigint(20) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 BINARY(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` binary(5) DEFAULT NULL, `c1` bigint(20) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 REAL NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` double DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 BINARY(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` binary(5) DEFAULT NULL, `c1` double DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 DOUBLE NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` double DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 BINARY(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` binary(5) DEFAULT NULL, `c1` double DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 FLOAT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` float DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 BINARY(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` binary(5) DEFAULT NULL, `c1` float DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 DECIMAL NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` decimal(10,0) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 BINARY(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` binary(5) DEFAULT NULL, `c1` decimal(10,0) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 NUMERIC NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` decimal(10,0) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 BINARY(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` binary(5) DEFAULT NULL, `c1` decimal(10,0) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 DATE NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` date DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 BINARY(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` binary(5) DEFAULT NULL, `c1` date DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 TIME NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` time DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 BINARY(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` binary(5) DEFAULT NULL, `c1` time DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 TIMESTAMP NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` timestamp NULL DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 BINARY(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` binary(5) DEFAULT NULL, `c1` timestamp NULL DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 YEAR NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` year(4) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 BINARY(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` binary(5) DEFAULT NULL, `c1` year(4) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 TINYBLOB NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` tinyblob DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 BINARY(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` binary(5) DEFAULT NULL, `c1` tinyblob DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 BLOB NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` blob DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 BINARY(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` binary(5) DEFAULT NULL, `c1` blob DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 MEDIUMBLOB NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` mediumblob DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 BINARY(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` binary(5) DEFAULT NULL, `c1` mediumblob DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 LONGBLOB NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` longblob DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 BINARY(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` binary(5) DEFAULT NULL, `c1` longblob DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 TINYTEXT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` tinytext DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 BINARY(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` binary(5) DEFAULT NULL, `c1` tinytext DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 TEXT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` text DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 BINARY(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` binary(5) DEFAULT NULL, `c1` text DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 MEDIUMTEXT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` mediumtext DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 BINARY(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` binary(5) DEFAULT NULL, `c1` mediumtext DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 LONGTEXT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` longtext DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 BINARY(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` binary(5) DEFAULT NULL, `c1` longtext DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 BIT NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` bit(1) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` binary(5) NOT NULL, `c1` bit(1) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 TINYINT NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` tinyint(4) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` binary(5) NOT NULL, `c1` tinyint(4) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 SMALLINT NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` smallint(6) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` binary(5) NOT NULL, `c1` smallint(6) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 MEDIUMINT NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` mediumint(9) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` binary(5) NOT NULL, `c1` mediumint(9) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 INT NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` int(11) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` binary(5) NOT NULL, `c1` int(11) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 INTEGER NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` int(11) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` binary(5) NOT NULL, `c1` int(11) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 BIGINT NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` bigint(20) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` binary(5) NOT NULL, `c1` bigint(20) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 REAL NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` double NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` binary(5) NOT NULL, `c1` double NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 DOUBLE NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` double NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` binary(5) NOT NULL, `c1` double NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 FLOAT NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` float NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` binary(5) NOT NULL, `c1` float NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 DECIMAL NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` decimal(10,0) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` binary(5) NOT NULL, `c1` decimal(10,0) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 NUMERIC NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` decimal(10,0) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` binary(5) NOT NULL, `c1` decimal(10,0) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 DATE NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` date NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` binary(5) NOT NULL, `c1` date NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 TIME NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` time NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` binary(5) NOT NULL, `c1` time NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 TIMESTAMP NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` binary(5) NOT NULL, `c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 YEAR NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` year(4) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` binary(5) NOT NULL, `c1` year(4) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 TINYBLOB NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` tinyblob NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` binary(5) NOT NULL, `c1` tinyblob NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 BLOB NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` blob NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` binary(5) NOT NULL, `c1` blob NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 MEDIUMBLOB NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` mediumblob NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` binary(5) NOT NULL, `c1` mediumblob NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 LONGBLOB NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` longblob NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` binary(5) NOT NULL, `c1` longblob NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 TINYTEXT NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` tinytext NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` binary(5) NOT NULL, `c1` tinytext NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 TEXT NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` text NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` binary(5) NOT NULL, `c1` text NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 MEDIUMTEXT NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` mediumtext NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` binary(5) NOT NULL, `c1` mediumtext NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 LONGTEXT NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` longtext NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 BINARY(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` binary(5) NOT NULL, `c1` longtext NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 BIT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` bit(1) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varbinary(5) DEFAULT NULL, `c1` bit(1) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 TINYINT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` tinyint(4) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varbinary(5) DEFAULT NULL, `c1` tinyint(4) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 SMALLINT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` smallint(6) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varbinary(5) DEFAULT NULL, `c1` smallint(6) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 MEDIUMINT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` mediumint(9) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varbinary(5) DEFAULT NULL, `c1` mediumint(9) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 INT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` int(11) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varbinary(5) DEFAULT NULL, `c1` int(11) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 INTEGER NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` int(11) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varbinary(5) DEFAULT NULL, `c1` int(11) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 BIGINT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` bigint(20) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varbinary(5) DEFAULT NULL, `c1` bigint(20) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 REAL NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` double DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varbinary(5) DEFAULT NULL, `c1` double DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 DOUBLE NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` double DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varbinary(5) DEFAULT NULL, `c1` double DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 FLOAT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` float DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varbinary(5) DEFAULT NULL, `c1` float DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 DECIMAL NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` decimal(10,0) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varbinary(5) DEFAULT NULL, `c1` decimal(10,0) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 NUMERIC NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` decimal(10,0) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varbinary(5) DEFAULT NULL, `c1` decimal(10,0) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 DATE NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` date DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varbinary(5) DEFAULT NULL, `c1` date DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 TIME NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` time DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varbinary(5) DEFAULT NULL, `c1` time DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 TIMESTAMP NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` timestamp NULL DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varbinary(5) DEFAULT NULL, `c1` timestamp NULL DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 YEAR NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` year(4) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varbinary(5) DEFAULT NULL, `c1` year(4) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 TINYBLOB NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` tinyblob DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varbinary(5) DEFAULT NULL, `c1` tinyblob DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 BLOB NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` blob DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varbinary(5) DEFAULT NULL, `c1` blob DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 MEDIUMBLOB NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` mediumblob DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varbinary(5) DEFAULT NULL, `c1` mediumblob DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 LONGBLOB NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` longblob DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varbinary(5) DEFAULT NULL, `c1` longblob DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 TINYTEXT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` tinytext DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varbinary(5) DEFAULT NULL, `c1` tinytext DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 TEXT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` text DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varbinary(5) DEFAULT NULL, `c1` text DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 MEDIUMTEXT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` mediumtext DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varbinary(5) DEFAULT NULL, `c1` mediumtext DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 LONGTEXT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` longtext DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varbinary(5) DEFAULT NULL, `c1` longtext DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 BIT NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` bit(1) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varbinary(5) NOT NULL, `c1` bit(1) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 TINYINT NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` tinyint(4) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varbinary(5) NOT NULL, `c1` tinyint(4) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 SMALLINT NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` smallint(6) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varbinary(5) NOT NULL, `c1` smallint(6) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 MEDIUMINT NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` mediumint(9) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varbinary(5) NOT NULL, `c1` mediumint(9) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 INT NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` int(11) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varbinary(5) NOT NULL, `c1` int(11) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 INTEGER NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` int(11) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varbinary(5) NOT NULL, `c1` int(11) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 BIGINT NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` bigint(20) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varbinary(5) NOT NULL, `c1` bigint(20) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 REAL NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` double NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varbinary(5) NOT NULL, `c1` double NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 DOUBLE NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` double NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varbinary(5) NOT NULL, `c1` double NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 FLOAT NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` float NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varbinary(5) NOT NULL, `c1` float NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 DECIMAL NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` decimal(10,0) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varbinary(5) NOT NULL, `c1` decimal(10,0) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 NUMERIC NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` decimal(10,0) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varbinary(5) NOT NULL, `c1` decimal(10,0) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 DATE NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` date NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varbinary(5) NOT NULL, `c1` date NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 TIME NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` time NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varbinary(5) NOT NULL, `c1` time NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 TIMESTAMP NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varbinary(5) NOT NULL, `c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 YEAR NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` year(4) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varbinary(5) NOT NULL, `c1` year(4) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 TINYBLOB NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` tinyblob NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varbinary(5) NOT NULL, `c1` tinyblob NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 BLOB NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` blob NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varbinary(5) NOT NULL, `c1` blob NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 MEDIUMBLOB NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` mediumblob NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varbinary(5) NOT NULL, `c1` mediumblob NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 LONGBLOB NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` longblob NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varbinary(5) NOT NULL, `c1` longblob NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 TINYTEXT NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` tinytext NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varbinary(5) NOT NULL, `c1` tinytext NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 TEXT NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` text NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varbinary(5) NOT NULL, `c1` text NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 MEDIUMTEXT NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` mediumtext NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varbinary(5) NOT NULL, `c1` mediumtext NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test CREATE TABLE t5(c1 LONGTEXT NOT NULL); SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` longtext NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARBINARY(5) NOT NULL FIRST; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c2` varbinary(5) NOT NULL, `c1` longtext NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test