Edit File: tc_column_default_number.result
DROP TABLE IF EXISTS t11; CREATE TABLE t11(c1 TINYINT(5) NULL DEFAULT 1); SHOW TABLES; Tables_in_test t11 SHOW CREATE TABLE t11; Table Create Table t11 CREATE TABLE `t11` ( `c1` tinyint(5) DEFAULT '1' ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t11; SHOW TABLES; Tables_in_test CREATE TABLE t11(c1 SMALLINT(5) NULL DEFAULT 1); SHOW TABLES; Tables_in_test t11 SHOW CREATE TABLE t11; Table Create Table t11 CREATE TABLE `t11` ( `c1` smallint(5) DEFAULT '1' ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t11; SHOW TABLES; Tables_in_test CREATE TABLE t11(c1 MEDIUMINT(5) NULL DEFAULT 1); SHOW TABLES; Tables_in_test t11 SHOW CREATE TABLE t11; Table Create Table t11 CREATE TABLE `t11` ( `c1` mediumint(5) DEFAULT '1' ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t11; SHOW TABLES; Tables_in_test CREATE TABLE t11(c1 INT(5) NULL DEFAULT 1); SHOW TABLES; Tables_in_test t11 SHOW CREATE TABLE t11; Table Create Table t11 CREATE TABLE `t11` ( `c1` int(5) DEFAULT '1' ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t11; SHOW TABLES; Tables_in_test CREATE TABLE t11(c1 INTEGER(5) NULL DEFAULT 1); SHOW TABLES; Tables_in_test t11 SHOW CREATE TABLE t11; Table Create Table t11 CREATE TABLE `t11` ( `c1` int(5) DEFAULT '1' ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t11; SHOW TABLES; Tables_in_test CREATE TABLE t11(c1 BIGINT(5) NULL DEFAULT 1); SHOW TABLES; Tables_in_test t11 SHOW CREATE TABLE t11; Table Create Table t11 CREATE TABLE `t11` ( `c1` bigint(5) DEFAULT '1' ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t11; SHOW TABLES; Tables_in_test CREATE TABLE t11(c1 TINYINT(5) NOT NULL DEFAULT 1); SHOW TABLES; Tables_in_test t11 SHOW CREATE TABLE t11; Table Create Table t11 CREATE TABLE `t11` ( `c1` tinyint(5) NOT NULL DEFAULT '1' ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t11; SHOW TABLES; Tables_in_test CREATE TABLE t11(c1 SMALLINT(5) NOT NULL DEFAULT 1); SHOW TABLES; Tables_in_test t11 SHOW CREATE TABLE t11; Table Create Table t11 CREATE TABLE `t11` ( `c1` smallint(5) NOT NULL DEFAULT '1' ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t11; SHOW TABLES; Tables_in_test CREATE TABLE t11(c1 MEDIUMINT(5) NOT NULL DEFAULT 1); SHOW TABLES; Tables_in_test t11 SHOW CREATE TABLE t11; Table Create Table t11 CREATE TABLE `t11` ( `c1` mediumint(5) NOT NULL DEFAULT '1' ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t11; SHOW TABLES; Tables_in_test CREATE TABLE t11(c1 INT(5) NOT NULL DEFAULT 1); SHOW TABLES; Tables_in_test t11 SHOW CREATE TABLE t11; Table Create Table t11 CREATE TABLE `t11` ( `c1` int(5) NOT NULL DEFAULT '1' ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t11; SHOW TABLES; Tables_in_test CREATE TABLE t11(c1 INTEGER(5) NOT NULL DEFAULT 1); SHOW TABLES; Tables_in_test t11 SHOW CREATE TABLE t11; Table Create Table t11 CREATE TABLE `t11` ( `c1` int(5) NOT NULL DEFAULT '1' ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t11; SHOW TABLES; Tables_in_test CREATE TABLE t11(c1 BIGINT(5) NOT NULL DEFAULT 1); SHOW TABLES; Tables_in_test t11 SHOW CREATE TABLE t11; Table Create Table t11 CREATE TABLE `t11` ( `c1` bigint(5) NOT NULL DEFAULT '1' ) ENGINE=ENGINE DEFAULT CHARSET=latin1 DROP TABLE t11; SHOW TABLES; Tables_in_test
Back to File Manager