1
DROP TABLE IF EXISTS t9;
2
CREATE TABLE t9(c1 BIT NOT NULL KEY);
11
) ENGINE=ENGINE DEFAULT CHARSET=latin1
15
CREATE TABLE t9(c1 TINYINT NOT NULL KEY);
21
t9 CREATE TABLE `t9` (
22
`c1` tinyint(4) NOT NULL,
24
) ENGINE=ENGINE DEFAULT CHARSET=latin1
28
CREATE TABLE t9(c1 SMALLINT NOT NULL KEY);
34
t9 CREATE TABLE `t9` (
35
`c1` smallint(6) NOT NULL,
37
) ENGINE=ENGINE DEFAULT CHARSET=latin1
41
CREATE TABLE t9(c1 MEDIUMINT NOT NULL KEY);
47
t9 CREATE TABLE `t9` (
48
`c1` mediumint(9) NOT NULL,
50
) ENGINE=ENGINE DEFAULT CHARSET=latin1
54
CREATE TABLE t9(c1 INT NOT NULL KEY);
60
t9 CREATE TABLE `t9` (
61
`c1` int(11) NOT NULL,
63
) ENGINE=ENGINE DEFAULT CHARSET=latin1
67
CREATE TABLE t9(c1 INTEGER NOT NULL KEY);
73
t9 CREATE TABLE `t9` (
74
`c1` int(11) NOT NULL,
76
) ENGINE=ENGINE DEFAULT CHARSET=latin1
80
CREATE TABLE t9(c1 BIGINT NOT NULL KEY);
86
t9 CREATE TABLE `t9` (
87
`c1` bigint(20) NOT NULL,
89
) ENGINE=ENGINE DEFAULT CHARSET=latin1
93
CREATE TABLE t9(c1 DECIMAL NOT NULL KEY);
99
t9 CREATE TABLE `t9` (
100
`c1` decimal(10,0) NOT NULL,
102
) ENGINE=ENGINE DEFAULT CHARSET=latin1
106
CREATE TABLE t9(c1 DEC NOT NULL KEY);
110
SHOW CREATE TABLE t9;
112
t9 CREATE TABLE `t9` (
113
`c1` decimal(10,0) NOT NULL,
115
) ENGINE=ENGINE DEFAULT CHARSET=latin1
119
CREATE TABLE t9(c1 FIXED NOT NULL KEY);
123
SHOW CREATE TABLE t9;
125
t9 CREATE TABLE `t9` (
126
`c1` decimal(10,0) NOT NULL,
128
) ENGINE=ENGINE DEFAULT CHARSET=latin1
132
CREATE TABLE t9(c1 NUMERIC NOT NULL KEY);
136
SHOW CREATE TABLE t9;
138
t9 CREATE TABLE `t9` (
139
`c1` decimal(10,0) NOT NULL,
141
) ENGINE=ENGINE DEFAULT CHARSET=latin1
145
CREATE TABLE t9(c1 DOUBLE NOT NULL KEY);
149
SHOW CREATE TABLE t9;
151
t9 CREATE TABLE `t9` (
152
`c1` double NOT NULL,
154
) ENGINE=ENGINE DEFAULT CHARSET=latin1
158
CREATE TABLE t9(c1 REAL NOT NULL KEY);
162
SHOW CREATE TABLE t9;
164
t9 CREATE TABLE `t9` (
165
`c1` double NOT NULL,
167
) ENGINE=ENGINE DEFAULT CHARSET=latin1
171
CREATE TABLE t9(c1 DOUBLE PRECISION NOT NULL KEY);
175
SHOW CREATE TABLE t9;
177
t9 CREATE TABLE `t9` (
178
`c1` double NOT NULL,
180
) ENGINE=ENGINE DEFAULT CHARSET=latin1
184
CREATE TABLE t9(c1 FLOAT NOT NULL KEY);
188
SHOW CREATE TABLE t9;
190
t9 CREATE TABLE `t9` (
193
) ENGINE=ENGINE DEFAULT CHARSET=latin1
197
CREATE TABLE t9(c1 DATE NOT NULL KEY);
201
SHOW CREATE TABLE t9;
203
t9 CREATE TABLE `t9` (
206
) ENGINE=ENGINE DEFAULT CHARSET=latin1
210
CREATE TABLE t9(c1 TIME NOT NULL KEY);
214
SHOW CREATE TABLE t9;
216
t9 CREATE TABLE `t9` (
219
) ENGINE=ENGINE DEFAULT CHARSET=latin1
223
CREATE TABLE t9(c1 TIMESTAMP NOT NULL KEY);
227
SHOW CREATE TABLE t9;
229
t9 CREATE TABLE `t9` (
230
`c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
232
) ENGINE=ENGINE DEFAULT CHARSET=latin1
236
CREATE TABLE t9(c1 DATETIME NOT NULL KEY);
240
SHOW CREATE TABLE t9;
242
t9 CREATE TABLE `t9` (
243
`c1` datetime NOT NULL,
245
) ENGINE=ENGINE DEFAULT CHARSET=latin1
249
CREATE TABLE t9(c1 YEAR NOT NULL KEY);
253
SHOW CREATE TABLE t9;
255
t9 CREATE TABLE `t9` (
256
`c1` year(4) NOT NULL,
258
) ENGINE=ENGINE DEFAULT CHARSET=latin1