1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1(c1 BIT NULL) COMMENT = 'This table has a BIT column';
9 `c1` bit(1) DEFAULT NULL
10 ) ENGINE=ENGINE DEFAULT CHARSET=latin1 COMMENT='This table has a BIT column'
14 CREATE TABLE t1(c1 TINYINT NULL) COMMENT = 'This table has a TINYINT column';
20 t1 CREATE TABLE `t1` (
21 `c1` tinyint(4) DEFAULT NULL
22 ) ENGINE=ENGINE DEFAULT CHARSET=latin1 COMMENT='This table has a TINYINT column'
26 CREATE TABLE t1(c1 SMALLINT NULL) COMMENT = 'This table has a SMALLINT column';
32 t1 CREATE TABLE `t1` (
33 `c1` smallint(6) DEFAULT NULL
34 ) ENGINE=ENGINE DEFAULT CHARSET=latin1 COMMENT='This table has a SMALLINT column'
38 CREATE TABLE t1(c1 MEDIUMINT NULL) COMMENT = 'This table has a MEDIUMINT column';
44 t1 CREATE TABLE `t1` (
45 `c1` mediumint(9) DEFAULT NULL
46 ) ENGINE=ENGINE DEFAULT CHARSET=latin1 COMMENT='This table has a MEDIUMINT column'
50 CREATE TABLE t1(c1 INT NULL) COMMENT = 'This table has a INT column';
56 t1 CREATE TABLE `t1` (
57 `c1` int(11) DEFAULT NULL
58 ) ENGINE=ENGINE DEFAULT CHARSET=latin1 COMMENT='This table has a INT column'
62 CREATE TABLE t1(c1 INTEGER NULL) COMMENT = 'This table has a INTEGER column';
68 t1 CREATE TABLE `t1` (
69 `c1` int(11) DEFAULT NULL
70 ) ENGINE=ENGINE DEFAULT CHARSET=latin1 COMMENT='This table has a INTEGER column'
74 CREATE TABLE t1(c1 BIGINT NULL) COMMENT = 'This table has a BIGINT column';
80 t1 CREATE TABLE `t1` (
81 `c1` bigint(20) DEFAULT NULL
82 ) ENGINE=ENGINE DEFAULT CHARSET=latin1 COMMENT='This table has a BIGINT column'
86 CREATE TABLE t1(c1 REAL NULL) COMMENT = 'This table has a REAL column';
92 t1 CREATE TABLE `t1` (
93 `c1` double DEFAULT NULL
94 ) ENGINE=ENGINE DEFAULT CHARSET=latin1 COMMENT='This table has a REAL column'
98 CREATE TABLE t1(c1 DOUBLE NULL) COMMENT = 'This table has a DOUBLE column';
102 SHOW CREATE TABLE t1;
104 t1 CREATE TABLE `t1` (
105 `c1` double DEFAULT NULL
106 ) ENGINE=ENGINE DEFAULT CHARSET=latin1 COMMENT='This table has a DOUBLE column'
110 CREATE TABLE t1(c1 FLOAT NULL) COMMENT = 'This table has a FLOAT column';
114 SHOW CREATE TABLE t1;
116 t1 CREATE TABLE `t1` (
117 `c1` float DEFAULT NULL
118 ) ENGINE=ENGINE DEFAULT CHARSET=latin1 COMMENT='This table has a FLOAT column'
122 CREATE TABLE t1(c1 DECIMAL NULL) COMMENT = 'This table has a DECIMAL column';
126 SHOW CREATE TABLE t1;
128 t1 CREATE TABLE `t1` (
129 `c1` decimal(10,0) DEFAULT NULL
130 ) ENGINE=ENGINE DEFAULT CHARSET=latin1 COMMENT='This table has a DECIMAL column'
134 CREATE TABLE t1(c1 NUMERIC NULL) COMMENT = 'This table has a NUMERIC column';
138 SHOW CREATE TABLE t1;
140 t1 CREATE TABLE `t1` (
141 `c1` decimal(10,0) DEFAULT NULL
142 ) ENGINE=ENGINE DEFAULT CHARSET=latin1 COMMENT='This table has a NUMERIC column'
146 CREATE TABLE t1(c1 DATE NULL) COMMENT = 'This table has a DATE column';
150 SHOW CREATE TABLE t1;
152 t1 CREATE TABLE `t1` (
153 `c1` date DEFAULT NULL
154 ) ENGINE=ENGINE DEFAULT CHARSET=latin1 COMMENT='This table has a DATE column'
158 CREATE TABLE t1(c1 TIME NULL) COMMENT = 'This table has a TIME column';
162 SHOW CREATE TABLE t1;
164 t1 CREATE TABLE `t1` (
165 `c1` time DEFAULT NULL
166 ) ENGINE=ENGINE DEFAULT CHARSET=latin1 COMMENT='This table has a TIME column'
170 CREATE TABLE t1(c1 DATETIME NULL) COMMENT = 'This table has a DATETIME column';
174 SHOW CREATE TABLE t1;
176 t1 CREATE TABLE `t1` (
177 `c1` datetime DEFAULT NULL
178 ) ENGINE=ENGINE DEFAULT CHARSET=latin1 COMMENT='This table has a DATETIME column'
182 CREATE TABLE t1(c1 TIMESTAMP NULL) COMMENT = 'This table has a TIMESTAMP column';
186 SHOW CREATE TABLE t1;
188 t1 CREATE TABLE `t1` (
189 `c1` timestamp NULL DEFAULT NULL
190 ) ENGINE=ENGINE DEFAULT CHARSET=latin1 COMMENT='This table has a TIMESTAMP column'
194 CREATE TABLE t1(c1 YEAR NULL) COMMENT = 'This table has a YEAR column';
198 SHOW CREATE TABLE t1;
200 t1 CREATE TABLE `t1` (
201 `c1` year(4) DEFAULT NULL
202 ) ENGINE=ENGINE DEFAULT CHARSET=latin1 COMMENT='This table has a YEAR column'
206 CREATE TABLE t1(c1 TINYBLOB NULL) COMMENT = 'This table has a TINYBLOB column';
210 SHOW CREATE TABLE t1;
212 t1 CREATE TABLE `t1` (
214 ) ENGINE=ENGINE DEFAULT CHARSET=latin1 COMMENT='This table has a TINYBLOB column'
218 CREATE TABLE t1(c1 BLOB NULL) COMMENT = 'This table has a BLOB column';
222 SHOW CREATE TABLE t1;
224 t1 CREATE TABLE `t1` (
226 ) ENGINE=ENGINE DEFAULT CHARSET=latin1 COMMENT='This table has a BLOB column'
230 CREATE TABLE t1(c1 MEDIUMBLOB NULL) COMMENT = 'This table has a MEDIUMBLOB column';
234 SHOW CREATE TABLE t1;
236 t1 CREATE TABLE `t1` (
238 ) ENGINE=ENGINE DEFAULT CHARSET=latin1 COMMENT='This table has a MEDIUMBLOB column'
242 CREATE TABLE t1(c1 LONGBLOB NULL) COMMENT = 'This table has a LONGBLOB column';
246 SHOW CREATE TABLE t1;
248 t1 CREATE TABLE `t1` (
250 ) ENGINE=ENGINE DEFAULT CHARSET=latin1 COMMENT='This table has a LONGBLOB column'
254 CREATE TABLE t1(c1 TINYTEXT NULL) COMMENT = 'This table has a TINYTEXT column';
258 SHOW CREATE TABLE t1;
260 t1 CREATE TABLE `t1` (
262 ) ENGINE=ENGINE DEFAULT CHARSET=latin1 COMMENT='This table has a TINYTEXT column'
266 CREATE TABLE t1(c1 TEXT NULL) COMMENT = 'This table has a TEXT column';
270 SHOW CREATE TABLE t1;
272 t1 CREATE TABLE `t1` (
274 ) ENGINE=ENGINE DEFAULT CHARSET=latin1 COMMENT='This table has a TEXT column'
278 CREATE TABLE t1(c1 MEDIUMTEXT NULL) COMMENT = 'This table has a MEDIUMTEXT column';
282 SHOW CREATE TABLE t1;
284 t1 CREATE TABLE `t1` (
286 ) ENGINE=ENGINE DEFAULT CHARSET=latin1 COMMENT='This table has a MEDIUMTEXT column'
290 CREATE TABLE t1(c1 LONGTEXT NULL) COMMENT = 'This table has a LONGTEXT column';
294 SHOW CREATE TABLE t1;
296 t1 CREATE TABLE `t1` (
298 ) ENGINE=ENGINE DEFAULT CHARSET=latin1 COMMENT='This table has a LONGTEXT column'