Edit File: ta_add_string2.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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` bit(1) DEFAULT NULL, `c2` char(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` tinyint(4) DEFAULT NULL, `c2` char(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` smallint(6) DEFAULT NULL, `c2` char(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` mediumint(9) DEFAULT NULL, `c2` char(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` int(11) DEFAULT NULL, `c2` char(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` int(11) DEFAULT NULL, `c2` char(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` bigint(20) DEFAULT NULL, `c2` char(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` double DEFAULT NULL, `c2` char(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` double DEFAULT NULL, `c2` char(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` float DEFAULT NULL, `c2` char(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` decimal(10,0) DEFAULT NULL, `c2` char(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` decimal(10,0) DEFAULT NULL, `c2` char(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` date DEFAULT NULL, `c2` char(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` time DEFAULT NULL, `c2` char(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` timestamp NULL DEFAULT NULL, `c2` char(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` year(4) DEFAULT NULL, `c2` char(5) 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 ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 CHAR(5) NULL; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` tinyblob, `c2` char(5) 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 ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 CHAR(5) NULL; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` blob, `c2` char(5) 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 ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 CHAR(5) NULL; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` mediumblob, `c2` char(5) 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 ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 CHAR(5) NULL; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` longblob, `c2` char(5) 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 ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 CHAR(5) NULL; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` tinytext, `c2` char(5) 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 ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 CHAR(5) NULL; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` text, `c2` char(5) 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 ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 CHAR(5) NULL; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` mediumtext, `c2` char(5) 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 ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 CHAR(5) NULL; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` longtext, `c2` char(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` bit(1) NOT NULL, `c2` char(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` tinyint(4) NOT NULL, `c2` char(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` smallint(6) NOT NULL, `c2` char(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` mediumint(9) NOT NULL, `c2` char(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` int(11) NOT NULL, `c2` char(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` int(11) NOT NULL, `c2` char(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` bigint(20) NOT NULL, `c2` char(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` double NOT NULL, `c2` char(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` double NOT NULL, `c2` char(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` float NOT NULL, `c2` char(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` decimal(10,0) NOT NULL, `c2` char(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` decimal(10,0) NOT NULL, `c2` char(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` date NOT NULL, `c2` char(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` time NOT NULL, `c2` char(5) 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; 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, `c2` char(5) NOT NULL ) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` year(4) NOT NULL, `c2` char(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` tinyblob NOT NULL, `c2` char(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` blob NOT NULL, `c2` char(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` mediumblob NOT NULL, `c2` char(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` longblob NOT NULL, `c2` char(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` tinytext NOT NULL, `c2` char(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` text NOT NULL, `c2` char(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` mediumtext NOT NULL, `c2` char(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` longtext NOT NULL, `c2` char(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` bit(1) DEFAULT NULL, `c2` varchar(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` tinyint(4) DEFAULT NULL, `c2` varchar(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` smallint(6) DEFAULT NULL, `c2` varchar(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` mediumint(9) DEFAULT NULL, `c2` varchar(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` int(11) DEFAULT NULL, `c2` varchar(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` int(11) DEFAULT NULL, `c2` varchar(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` bigint(20) DEFAULT NULL, `c2` varchar(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` double DEFAULT NULL, `c2` varchar(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` double DEFAULT NULL, `c2` varchar(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` float DEFAULT NULL, `c2` varchar(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` decimal(10,0) DEFAULT NULL, `c2` varchar(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` decimal(10,0) DEFAULT NULL, `c2` varchar(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` date DEFAULT NULL, `c2` varchar(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` time DEFAULT NULL, `c2` varchar(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` timestamp NULL DEFAULT NULL, `c2` varchar(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` year(4) DEFAULT NULL, `c2` varchar(5) 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 ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` tinyblob, `c2` varchar(5) 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 ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` blob, `c2` varchar(5) 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 ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` mediumblob, `c2` varchar(5) 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 ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` longblob, `c2` varchar(5) 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 ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` tinytext, `c2` varchar(5) 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 ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` text, `c2` varchar(5) 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 ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` mediumtext, `c2` varchar(5) 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 ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARCHAR(5) NULL; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` longtext, `c2` varchar(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` bit(1) NOT NULL, `c2` varchar(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` tinyint(4) NOT NULL, `c2` varchar(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` smallint(6) NOT NULL, `c2` varchar(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` mediumint(9) NOT NULL, `c2` varchar(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` int(11) NOT NULL, `c2` varchar(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` int(11) NOT NULL, `c2` varchar(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` bigint(20) NOT NULL, `c2` varchar(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` double NOT NULL, `c2` varchar(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` double NOT NULL, `c2` varchar(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` float NOT NULL, `c2` varchar(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` decimal(10,0) NOT NULL, `c2` varchar(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` decimal(10,0) NOT NULL, `c2` varchar(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` date NOT NULL, `c2` varchar(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` time NOT NULL, `c2` varchar(5) 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; 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, `c2` varchar(5) NOT NULL ) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` year(4) NOT NULL, `c2` varchar(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` tinyblob NOT NULL, `c2` varchar(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` blob NOT NULL, `c2` varchar(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` mediumblob NOT NULL, `c2` varchar(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` longblob NOT NULL, `c2` varchar(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` tinytext NOT NULL, `c2` varchar(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` text NOT NULL, `c2` varchar(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` mediumtext NOT NULL, `c2` varchar(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` longtext NOT NULL, `c2` varchar(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` bit(1) DEFAULT NULL, `c2` binary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` tinyint(4) DEFAULT NULL, `c2` binary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` smallint(6) DEFAULT NULL, `c2` binary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` mediumint(9) DEFAULT NULL, `c2` binary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` int(11) DEFAULT NULL, `c2` binary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` int(11) DEFAULT NULL, `c2` binary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` bigint(20) DEFAULT NULL, `c2` binary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` double DEFAULT NULL, `c2` binary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` double DEFAULT NULL, `c2` binary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` float DEFAULT NULL, `c2` binary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` decimal(10,0) DEFAULT NULL, `c2` binary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` decimal(10,0) DEFAULT NULL, `c2` binary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` date DEFAULT NULL, `c2` binary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` time DEFAULT NULL, `c2` binary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` timestamp NULL DEFAULT NULL, `c2` binary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` year(4) DEFAULT NULL, `c2` binary(5) 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 ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 BINARY(5) NULL; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` tinyblob, `c2` binary(5) 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 ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 BINARY(5) NULL; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` blob, `c2` binary(5) 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 ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 BINARY(5) NULL; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` mediumblob, `c2` binary(5) 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 ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 BINARY(5) NULL; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` longblob, `c2` binary(5) 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 ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 BINARY(5) NULL; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` tinytext, `c2` binary(5) 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 ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 BINARY(5) NULL; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` text, `c2` binary(5) 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 ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 BINARY(5) NULL; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` mediumtext, `c2` binary(5) 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 ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 BINARY(5) NULL; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` longtext, `c2` binary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` bit(1) NOT NULL, `c2` binary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` tinyint(4) NOT NULL, `c2` binary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` smallint(6) NOT NULL, `c2` binary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` mediumint(9) NOT NULL, `c2` binary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` int(11) NOT NULL, `c2` binary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` int(11) NOT NULL, `c2` binary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` bigint(20) NOT NULL, `c2` binary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` double NOT NULL, `c2` binary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` double NOT NULL, `c2` binary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` float NOT NULL, `c2` binary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` decimal(10,0) NOT NULL, `c2` binary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` decimal(10,0) NOT NULL, `c2` binary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` date NOT NULL, `c2` binary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` time NOT NULL, `c2` binary(5) 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; 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, `c2` binary(5) NOT NULL ) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` year(4) NOT NULL, `c2` binary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` tinyblob NOT NULL, `c2` binary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` blob NOT NULL, `c2` binary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` mediumblob NOT NULL, `c2` binary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` longblob NOT NULL, `c2` binary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` tinytext NOT NULL, `c2` binary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` text NOT NULL, `c2` binary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` mediumtext NOT NULL, `c2` binary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` longtext NOT NULL, `c2` binary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` bit(1) DEFAULT NULL, `c2` varbinary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` tinyint(4) DEFAULT NULL, `c2` varbinary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` smallint(6) DEFAULT NULL, `c2` varbinary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` mediumint(9) DEFAULT NULL, `c2` varbinary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` int(11) DEFAULT NULL, `c2` varbinary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` int(11) DEFAULT NULL, `c2` varbinary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` bigint(20) DEFAULT NULL, `c2` varbinary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` double DEFAULT NULL, `c2` varbinary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` double DEFAULT NULL, `c2` varbinary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` float DEFAULT NULL, `c2` varbinary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` decimal(10,0) DEFAULT NULL, `c2` varbinary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` decimal(10,0) DEFAULT NULL, `c2` varbinary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` date DEFAULT NULL, `c2` varbinary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` time DEFAULT NULL, `c2` varbinary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` timestamp NULL DEFAULT NULL, `c2` varbinary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` year(4) DEFAULT NULL, `c2` varbinary(5) 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 ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` tinyblob, `c2` varbinary(5) 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 ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` blob, `c2` varbinary(5) 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 ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` mediumblob, `c2` varbinary(5) 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 ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` longblob, `c2` varbinary(5) 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 ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` tinytext, `c2` varbinary(5) 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 ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` text, `c2` varbinary(5) 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 ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` mediumtext, `c2` varbinary(5) 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 ) ENGINE=ENGINE DEFAULT CHARSET=latin1 ALTER TABLE t5 ADD c2 VARBINARY(5) NULL; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` longtext, `c2` varbinary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` bit(1) NOT NULL, `c2` varbinary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` tinyint(4) NOT NULL, `c2` varbinary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` smallint(6) NOT NULL, `c2` varbinary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` mediumint(9) NOT NULL, `c2` varbinary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` int(11) NOT NULL, `c2` varbinary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` int(11) NOT NULL, `c2` varbinary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` bigint(20) NOT NULL, `c2` varbinary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` double NOT NULL, `c2` varbinary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` double NOT NULL, `c2` varbinary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` float NOT NULL, `c2` varbinary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` decimal(10,0) NOT NULL, `c2` varbinary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` decimal(10,0) NOT NULL, `c2` varbinary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` date NOT NULL, `c2` varbinary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` time NOT NULL, `c2` varbinary(5) 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; 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, `c2` varbinary(5) NOT NULL ) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` year(4) NOT NULL, `c2` varbinary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` tinyblob NOT NULL, `c2` varbinary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` blob NOT NULL, `c2` varbinary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` mediumblob NOT NULL, `c2` varbinary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` longblob NOT NULL, `c2` varbinary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` tinytext NOT NULL, `c2` varbinary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` text NOT NULL, `c2` varbinary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` mediumtext NOT NULL, `c2` varbinary(5) 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; SHOW TABLES; Tables_in_test t5 SHOW CREATE TABLE t5; Table Create Table t5 CREATE TABLE `t5` ( `c1` longtext NOT NULL, `c2` varbinary(5) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t5; SHOW TABLES; Tables_in_test
Back to File Manager