mirror/mariadb
1
0
Fork 0
mirror of https://github.com/MariaDB/server.git synced 2025-10-31 19:06:14 +01:00
Code Issues Projects Releases Packages Wiki Activity
mariadb/mysql-test/suite/engines/funcs/r/tc_column_zerofill.result
Alexander Barkov 36eba98817 MDEV-19123 Change default charset from latin1 to utf8mb4 
Changing the default server character set from latin1 to utf8mb4.
2024-07-11 10:21:07 +04:00

673 lines
17 KiB
Text
Raw Permalink Blame History

DROP TABLE IF EXISTS t4;
CREATE TABLE t4(c1 TINYINT ZEROFILL NULL);
SHOW TABLES;
Tables_in_test
t4
SHOW CREATE TABLE t4;
Table Create Table
t4 CREATE TABLE `t4` (
`c1` tinyint(3) unsigned zerofill DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
CREATE TABLE t4(c1 SMALLINT ZEROFILL NULL);
SHOW TABLES;
Tables_in_test
t4
SHOW CREATE TABLE t4;
Table Create Table
t4 CREATE TABLE `t4` (
`c1` smallint(5) unsigned zerofill DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
CREATE TABLE t4(c1 MEDIUMINT ZEROFILL NULL);
SHOW TABLES;
Tables_in_test
t4
SHOW CREATE TABLE t4;
Table Create Table
t4 CREATE TABLE `t4` (
`c1` mediumint(8) unsigned zerofill DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
CREATE TABLE t4(c1 INT ZEROFILL NULL);
SHOW TABLES;
Tables_in_test
t4
SHOW CREATE TABLE t4;
Table Create Table
t4 CREATE TABLE `t4` (
`c1` int(10) unsigned zerofill DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
CREATE TABLE t4(c1 INTEGER ZEROFILL NULL);
SHOW TABLES;
Tables_in_test
t4
SHOW CREATE TABLE t4;
Table Create Table
t4 CREATE TABLE `t4` (
`c1` int(10) unsigned zerofill DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
CREATE TABLE t4(c1 BIGINT ZEROFILL NULL);
SHOW TABLES;
Tables_in_test
t4
SHOW CREATE TABLE t4;
Table Create Table
t4 CREATE TABLE `t4` (
`c1` bigint(20) unsigned zerofill DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
CREATE TABLE t4(c1 DECIMAL ZEROFILL NULL);
SHOW TABLES;
Tables_in_test
t4
SHOW CREATE TABLE t4;
Table Create Table
t4 CREATE TABLE `t4` (
`c1` decimal(10,0) unsigned zerofill DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
CREATE TABLE t4(c1 DEC ZEROFILL NULL);
SHOW TABLES;
Tables_in_test
t4
SHOW CREATE TABLE t4;
Table Create Table
t4 CREATE TABLE `t4` (
`c1` decimal(10,0) unsigned zerofill DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
CREATE TABLE t4(c1 FIXED ZEROFILL NULL);
SHOW TABLES;
Tables_in_test
t4
SHOW CREATE TABLE t4;
Table Create Table
t4 CREATE TABLE `t4` (
`c1` decimal(10,0) unsigned zerofill DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
CREATE TABLE t4(c1 NUMERIC ZEROFILL NULL);
SHOW TABLES;
Tables_in_test
t4
SHOW CREATE TABLE t4;
Table Create Table
t4 CREATE TABLE `t4` (
`c1` decimal(10,0) unsigned zerofill DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
CREATE TABLE t4(c1 DOUBLE ZEROFILL NULL);
SHOW TABLES;
Tables_in_test
t4
SHOW CREATE TABLE t4;
Table Create Table
t4 CREATE TABLE `t4` (
`c1` double unsigned zerofill DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
CREATE TABLE t4(c1 REAL ZEROFILL NULL);
SHOW TABLES;
Tables_in_test
t4
SHOW CREATE TABLE t4;
Table Create Table
t4 CREATE TABLE `t4` (
`c1` double unsigned zerofill DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
CREATE TABLE t4(c1 DOUBLE PRECISION ZEROFILL NULL);
SHOW TABLES;
Tables_in_test
t4
SHOW CREATE TABLE t4;
Table Create Table
t4 CREATE TABLE `t4` (
`c1` double unsigned zerofill DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
CREATE TABLE t4(c1 FLOAT ZEROFILL NULL);
SHOW TABLES;
Tables_in_test
t4
SHOW CREATE TABLE t4;
Table Create Table
t4 CREATE TABLE `t4` (
`c1` float unsigned zerofill DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
CREATE TABLE t4(c1 TINYINT UNSIGNED ZEROFILL NULL);
SHOW TABLES;
Tables_in_test
t4
SHOW CREATE TABLE t4;
Table Create Table
t4 CREATE TABLE `t4` (
`c1` tinyint(3) unsigned zerofill DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
CREATE TABLE t4(c1 SMALLINT UNSIGNED ZEROFILL NULL);
SHOW TABLES;
Tables_in_test
t4
SHOW CREATE TABLE t4;
Table Create Table
t4 CREATE TABLE `t4` (
`c1` smallint(5) unsigned zerofill DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
CREATE TABLE t4(c1 MEDIUMINT UNSIGNED ZEROFILL NULL);
SHOW TABLES;
Tables_in_test
t4
SHOW CREATE TABLE t4;
Table Create Table
t4 CREATE TABLE `t4` (
`c1` mediumint(8) unsigned zerofill DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
CREATE TABLE t4(c1 INT UNSIGNED ZEROFILL NULL);
SHOW TABLES;
Tables_in_test
t4
SHOW CREATE TABLE t4;
Table Create Table
t4 CREATE TABLE `t4` (
`c1` int(10) unsigned zerofill DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
CREATE TABLE t4(c1 INTEGER UNSIGNED ZEROFILL NULL);
SHOW TABLES;
Tables_in_test
t4
SHOW CREATE TABLE t4;
Table Create Table
t4 CREATE TABLE `t4` (
`c1` int(10) unsigned zerofill DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
CREATE TABLE t4(c1 BIGINT UNSIGNED ZEROFILL NULL);
SHOW TABLES;
Tables_in_test
t4
SHOW CREATE TABLE t4;
Table Create Table
t4 CREATE TABLE `t4` (
`c1` bigint(20) unsigned zerofill DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
CREATE TABLE t4(c1 DECIMAL UNSIGNED ZEROFILL NULL);
SHOW TABLES;
Tables_in_test
t4
SHOW CREATE TABLE t4;
Table Create Table
t4 CREATE TABLE `t4` (
`c1` decimal(10,0) unsigned zerofill DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
CREATE TABLE t4(c1 DEC UNSIGNED ZEROFILL NULL);
SHOW TABLES;
Tables_in_test
t4
SHOW CREATE TABLE t4;
Table Create Table
t4 CREATE TABLE `t4` (
`c1` decimal(10,0) unsigned zerofill DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
CREATE TABLE t4(c1 FIXED UNSIGNED ZEROFILL NULL);
SHOW TABLES;
Tables_in_test
t4
SHOW CREATE TABLE t4;
Table Create Table
t4 CREATE TABLE `t4` (
`c1` decimal(10,0) unsigned zerofill DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
CREATE TABLE t4(c1 NUMERIC UNSIGNED ZEROFILL NULL);
SHOW TABLES;
Tables_in_test
t4
SHOW CREATE TABLE t4;
Table Create Table
t4 CREATE TABLE `t4` (
`c1` decimal(10,0) unsigned zerofill DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
CREATE TABLE t4(c1 DOUBLE UNSIGNED ZEROFILL NULL);
SHOW TABLES;
Tables_in_test
t4
SHOW CREATE TABLE t4;
Table Create Table
t4 CREATE TABLE `t4` (
`c1` double unsigned zerofill DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
CREATE TABLE t4(c1 REAL UNSIGNED ZEROFILL NULL);
SHOW TABLES;
Tables_in_test
t4
SHOW CREATE TABLE t4;
Table Create Table
t4 CREATE TABLE `t4` (
`c1` double unsigned zerofill DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
CREATE TABLE t4(c1 DOUBLE PRECISION UNSIGNED ZEROFILL NULL);
SHOW TABLES;
Tables_in_test
t4
SHOW CREATE TABLE t4;
Table Create Table
t4 CREATE TABLE `t4` (
`c1` double unsigned zerofill DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
CREATE TABLE t4(c1 FLOAT UNSIGNED ZEROFILL NULL);
SHOW TABLES;
Tables_in_test
t4
SHOW CREATE TABLE t4;
Table Create Table
t4 CREATE TABLE `t4` (
`c1` float unsigned zerofill DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
CREATE TABLE t4(c1 TINYINT ZEROFILL NOT NULL);
SHOW TABLES;
Tables_in_test
t4
SHOW CREATE TABLE t4;
Table Create Table
t4 CREATE TABLE `t4` (
`c1` tinyint(3) unsigned zerofill NOT NULL
) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
CREATE TABLE t4(c1 SMALLINT ZEROFILL NOT NULL);
SHOW TABLES;
Tables_in_test
t4
SHOW CREATE TABLE t4;
Table Create Table
t4 CREATE TABLE `t4` (
`c1` smallint(5) unsigned zerofill NOT NULL
) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
CREATE TABLE t4(c1 MEDIUMINT ZEROFILL NOT NULL);
SHOW TABLES;
Tables_in_test
t4
SHOW CREATE TABLE t4;
Table Create Table
t4 CREATE TABLE `t4` (
`c1` mediumint(8) unsigned zerofill NOT NULL
) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
CREATE TABLE t4(c1 INT ZEROFILL NOT NULL);
SHOW TABLES;
Tables_in_test
t4
SHOW CREATE TABLE t4;
Table Create Table
t4 CREATE TABLE `t4` (
`c1` int(10) unsigned zerofill NOT NULL
) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
CREATE TABLE t4(c1 INTEGER ZEROFILL NOT NULL);
SHOW TABLES;
Tables_in_test
t4
SHOW CREATE TABLE t4;
Table Create Table
t4 CREATE TABLE `t4` (
`c1` int(10) unsigned zerofill NOT NULL
) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
CREATE TABLE t4(c1 BIGINT ZEROFILL NOT NULL);
SHOW TABLES;
Tables_in_test
t4
SHOW CREATE TABLE t4;
Table Create Table
t4 CREATE TABLE `t4` (
`c1` bigint(20) unsigned zerofill NOT NULL
) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
CREATE TABLE t4(c1 DECIMAL ZEROFILL NOT NULL);
SHOW TABLES;
Tables_in_test
t4
SHOW CREATE TABLE t4;
Table Create Table
t4 CREATE TABLE `t4` (
`c1` decimal(10,0) unsigned zerofill NOT NULL
) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
CREATE TABLE t4(c1 DEC ZEROFILL NOT NULL);
SHOW TABLES;
Tables_in_test
t4
SHOW CREATE TABLE t4;
Table Create Table
t4 CREATE TABLE `t4` (
`c1` decimal(10,0) unsigned zerofill NOT NULL
) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
CREATE TABLE t4(c1 FIXED ZEROFILL NOT NULL);
SHOW TABLES;
Tables_in_test
t4
SHOW CREATE TABLE t4;
Table Create Table
t4 CREATE TABLE `t4` (
`c1` decimal(10,0) unsigned zerofill NOT NULL
) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
CREATE TABLE t4(c1 NUMERIC ZEROFILL NOT NULL);
SHOW TABLES;
Tables_in_test
t4
SHOW CREATE TABLE t4;
Table Create Table
t4 CREATE TABLE `t4` (
`c1` decimal(10,0) unsigned zerofill NOT NULL
) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
CREATE TABLE t4(c1 DOUBLE ZEROFILL NOT NULL);
SHOW TABLES;
Tables_in_test
t4
SHOW CREATE TABLE t4;
Table Create Table
t4 CREATE TABLE `t4` (
`c1` double unsigned zerofill NOT NULL
) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
CREATE TABLE t4(c1 REAL ZEROFILL NOT NULL);
SHOW TABLES;
Tables_in_test
t4
SHOW CREATE TABLE t4;
Table Create Table
t4 CREATE TABLE `t4` (
`c1` double unsigned zerofill NOT NULL
) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
CREATE TABLE t4(c1 DOUBLE PRECISION ZEROFILL NOT NULL);
SHOW TABLES;
Tables_in_test
t4
SHOW CREATE TABLE t4;
Table Create Table
t4 CREATE TABLE `t4` (
`c1` double unsigned zerofill NOT NULL
) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
CREATE TABLE t4(c1 FLOAT ZEROFILL NOT NULL);
SHOW TABLES;
Tables_in_test
t4
SHOW CREATE TABLE t4;
Table Create Table
t4 CREATE TABLE `t4` (
`c1` float unsigned zerofill NOT NULL
) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
CREATE TABLE t4(c1 TINYINT UNSIGNED ZEROFILL NOT NULL);
SHOW TABLES;
Tables_in_test
t4
SHOW CREATE TABLE t4;
Table Create Table
t4 CREATE TABLE `t4` (
`c1` tinyint(3) unsigned zerofill NOT NULL
) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
CREATE TABLE t4(c1 SMALLINT UNSIGNED ZEROFILL NOT NULL);
SHOW TABLES;
Tables_in_test
t4
SHOW CREATE TABLE t4;
Table Create Table
t4 CREATE TABLE `t4` (
`c1` smallint(5) unsigned zerofill NOT NULL
) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
CREATE TABLE t4(c1 MEDIUMINT UNSIGNED ZEROFILL NOT NULL);
SHOW TABLES;
Tables_in_test
t4
SHOW CREATE TABLE t4;
Table Create Table
t4 CREATE TABLE `t4` (
`c1` mediumint(8) unsigned zerofill NOT NULL
) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
CREATE TABLE t4(c1 INT UNSIGNED ZEROFILL NOT NULL);
SHOW TABLES;
Tables_in_test
t4
SHOW CREATE TABLE t4;
Table Create Table
t4 CREATE TABLE `t4` (
`c1` int(10) unsigned zerofill NOT NULL
) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
CREATE TABLE t4(c1 INTEGER UNSIGNED ZEROFILL NOT NULL);
SHOW TABLES;
Tables_in_test
t4
SHOW CREATE TABLE t4;
Table Create Table
t4 CREATE TABLE `t4` (
`c1` int(10) unsigned zerofill NOT NULL
) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
CREATE TABLE t4(c1 BIGINT UNSIGNED ZEROFILL NOT NULL);
SHOW TABLES;
Tables_in_test
t4
SHOW CREATE TABLE t4;
Table Create Table
t4 CREATE TABLE `t4` (
`c1` bigint(20) unsigned zerofill NOT NULL
) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
CREATE TABLE t4(c1 DECIMAL UNSIGNED ZEROFILL NOT NULL);
SHOW TABLES;
Tables_in_test
t4
SHOW CREATE TABLE t4;
Table Create Table
t4 CREATE TABLE `t4` (
`c1` decimal(10,0) unsigned zerofill NOT NULL
) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
CREATE TABLE t4(c1 DEC UNSIGNED ZEROFILL NOT NULL);
SHOW TABLES;
Tables_in_test
t4
SHOW CREATE TABLE t4;
Table Create Table
t4 CREATE TABLE `t4` (
`c1` decimal(10,0) unsigned zerofill NOT NULL
) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
CREATE TABLE t4(c1 FIXED UNSIGNED ZEROFILL NOT NULL);
SHOW TABLES;
Tables_in_test
t4
SHOW CREATE TABLE t4;
Table Create Table
t4 CREATE TABLE `t4` (
`c1` decimal(10,0) unsigned zerofill NOT NULL
) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
CREATE TABLE t4(c1 NUMERIC UNSIGNED ZEROFILL NOT NULL);
SHOW TABLES;
Tables_in_test
t4
SHOW CREATE TABLE t4;
Table Create Table
t4 CREATE TABLE `t4` (
`c1` decimal(10,0) unsigned zerofill NOT NULL
) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
CREATE TABLE t4(c1 DOUBLE UNSIGNED ZEROFILL NOT NULL);
SHOW TABLES;
Tables_in_test
t4
SHOW CREATE TABLE t4;
Table Create Table
t4 CREATE TABLE `t4` (
`c1` double unsigned zerofill NOT NULL
) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
CREATE TABLE t4(c1 REAL UNSIGNED ZEROFILL NOT NULL);
SHOW TABLES;
Tables_in_test
t4
SHOW CREATE TABLE t4;
Table Create Table
t4 CREATE TABLE `t4` (
`c1` double unsigned zerofill NOT NULL
) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
CREATE TABLE t4(c1 DOUBLE PRECISION UNSIGNED ZEROFILL NOT NULL);
SHOW TABLES;
Tables_in_test
t4
SHOW CREATE TABLE t4;
Table Create Table
t4 CREATE TABLE `t4` (
`c1` double unsigned zerofill NOT NULL
) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
CREATE TABLE t4(c1 FLOAT UNSIGNED ZEROFILL NOT NULL);
SHOW TABLES;
Tables_in_test
t4
SHOW CREATE TABLE t4;
Table Create Table
t4 CREATE TABLE `t4` (
`c1` float unsigned zerofill NOT NULL
) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
Reference in a new issue View git blame Copy permalink