1
DROP TABLE IF EXISTS t1;
2
CREATE TABLE t1(c1 BIT NOT NULL);
10
) ENGINE=ENGINE DEFAULT CHARSET=latin1
11
ALTER TABLE t1 ADD PRIMARY KEY (c1);
17
t1 CREATE TABLE `t1` (
20
) ENGINE=ENGINE DEFAULT CHARSET=latin1
24
CREATE TABLE t1(c1 TINYINT NOT NULL);
30
t1 CREATE TABLE `t1` (
31
`c1` tinyint(4) NOT NULL
32
) ENGINE=ENGINE DEFAULT CHARSET=latin1
33
ALTER TABLE t1 ADD PRIMARY KEY (c1);
39
t1 CREATE TABLE `t1` (
40
`c1` tinyint(4) NOT NULL,
42
) ENGINE=ENGINE DEFAULT CHARSET=latin1
46
CREATE TABLE t1(c1 SMALLINT NOT NULL);
52
t1 CREATE TABLE `t1` (
53
`c1` smallint(6) NOT NULL
54
) ENGINE=ENGINE DEFAULT CHARSET=latin1
55
ALTER TABLE t1 ADD PRIMARY KEY (c1);
61
t1 CREATE TABLE `t1` (
62
`c1` smallint(6) NOT NULL,
64
) ENGINE=ENGINE DEFAULT CHARSET=latin1
68
CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
74
t1 CREATE TABLE `t1` (
75
`c1` mediumint(9) NOT NULL
76
) ENGINE=ENGINE DEFAULT CHARSET=latin1
77
ALTER TABLE t1 ADD PRIMARY KEY (c1);
83
t1 CREATE TABLE `t1` (
84
`c1` mediumint(9) NOT NULL,
86
) ENGINE=ENGINE DEFAULT CHARSET=latin1
90
CREATE TABLE t1(c1 INT NOT NULL);
96
t1 CREATE TABLE `t1` (
98
) ENGINE=ENGINE DEFAULT CHARSET=latin1
99
ALTER TABLE t1 ADD PRIMARY KEY (c1);
103
SHOW CREATE TABLE t1;
105
t1 CREATE TABLE `t1` (
106
`c1` int(11) NOT NULL,
108
) ENGINE=ENGINE DEFAULT CHARSET=latin1
112
CREATE TABLE t1(c1 INTEGER NOT NULL);
116
SHOW CREATE TABLE t1;
118
t1 CREATE TABLE `t1` (
119
`c1` int(11) NOT NULL
120
) ENGINE=ENGINE DEFAULT CHARSET=latin1
121
ALTER TABLE t1 ADD PRIMARY KEY (c1);
125
SHOW CREATE TABLE t1;
127
t1 CREATE TABLE `t1` (
128
`c1` int(11) NOT NULL,
130
) ENGINE=ENGINE DEFAULT CHARSET=latin1
134
CREATE TABLE t1(c1 BIGINT NOT NULL);
138
SHOW CREATE TABLE t1;
140
t1 CREATE TABLE `t1` (
141
`c1` bigint(20) NOT NULL
142
) ENGINE=ENGINE DEFAULT CHARSET=latin1
143
ALTER TABLE t1 ADD PRIMARY KEY (c1);
147
SHOW CREATE TABLE t1;
149
t1 CREATE TABLE `t1` (
150
`c1` bigint(20) NOT NULL,
152
) ENGINE=ENGINE DEFAULT CHARSET=latin1
156
CREATE TABLE t1(c1 REAL NOT NULL);
160
SHOW CREATE TABLE t1;
162
t1 CREATE TABLE `t1` (
164
) ENGINE=ENGINE DEFAULT CHARSET=latin1
165
ALTER TABLE t1 ADD PRIMARY KEY (c1);
169
SHOW CREATE TABLE t1;
171
t1 CREATE TABLE `t1` (
172
`c1` double NOT NULL,
174
) ENGINE=ENGINE DEFAULT CHARSET=latin1
178
CREATE TABLE t1(c1 DOUBLE NOT NULL);
182
SHOW CREATE TABLE t1;
184
t1 CREATE TABLE `t1` (
186
) ENGINE=ENGINE DEFAULT CHARSET=latin1
187
ALTER TABLE t1 ADD PRIMARY KEY (c1);
191
SHOW CREATE TABLE t1;
193
t1 CREATE TABLE `t1` (
194
`c1` double NOT NULL,
196
) ENGINE=ENGINE DEFAULT CHARSET=latin1
200
CREATE TABLE t1(c1 FLOAT NOT NULL);
204
SHOW CREATE TABLE t1;
206
t1 CREATE TABLE `t1` (
208
) ENGINE=ENGINE DEFAULT CHARSET=latin1
209
ALTER TABLE t1 ADD PRIMARY KEY (c1);
213
SHOW CREATE TABLE t1;
215
t1 CREATE TABLE `t1` (
218
) ENGINE=ENGINE DEFAULT CHARSET=latin1
222
CREATE TABLE t1(c1 DECIMAL NOT NULL);
226
SHOW CREATE TABLE t1;
228
t1 CREATE TABLE `t1` (
229
`c1` decimal(10,0) NOT NULL
230
) ENGINE=ENGINE DEFAULT CHARSET=latin1
231
ALTER TABLE t1 ADD PRIMARY KEY (c1);
235
SHOW CREATE TABLE t1;
237
t1 CREATE TABLE `t1` (
238
`c1` decimal(10,0) NOT NULL,
240
) ENGINE=ENGINE DEFAULT CHARSET=latin1
244
CREATE TABLE t1(c1 NUMERIC NOT NULL);
248
SHOW CREATE TABLE t1;
250
t1 CREATE TABLE `t1` (
251
`c1` decimal(10,0) NOT NULL
252
) ENGINE=ENGINE DEFAULT CHARSET=latin1
253
ALTER TABLE t1 ADD PRIMARY KEY (c1);
257
SHOW CREATE TABLE t1;
259
t1 CREATE TABLE `t1` (
260
`c1` decimal(10,0) NOT NULL,
262
) ENGINE=ENGINE DEFAULT CHARSET=latin1
266
CREATE TABLE t1(c1 DATE NOT NULL);
270
SHOW CREATE TABLE t1;
272
t1 CREATE TABLE `t1` (
274
) ENGINE=ENGINE DEFAULT CHARSET=latin1
275
ALTER TABLE t1 ADD PRIMARY KEY (c1);
279
SHOW CREATE TABLE t1;
281
t1 CREATE TABLE `t1` (
284
) ENGINE=ENGINE DEFAULT CHARSET=latin1
288
CREATE TABLE t1(c1 TIME NOT NULL);
292
SHOW CREATE TABLE t1;
294
t1 CREATE TABLE `t1` (
296
) ENGINE=ENGINE DEFAULT CHARSET=latin1
297
ALTER TABLE t1 ADD PRIMARY KEY (c1);
301
SHOW CREATE TABLE t1;
303
t1 CREATE TABLE `t1` (
306
) ENGINE=ENGINE DEFAULT CHARSET=latin1
310
CREATE TABLE t1(c1 TIMESTAMP NOT NULL);
314
SHOW CREATE TABLE t1;
316
t1 CREATE TABLE `t1` (
317
`c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
318
) ENGINE=ENGINE DEFAULT CHARSET=latin1
319
ALTER TABLE t1 ADD PRIMARY KEY (c1);
323
SHOW CREATE TABLE t1;
325
t1 CREATE TABLE `t1` (
326
`c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
328
) ENGINE=ENGINE DEFAULT CHARSET=latin1
332
CREATE TABLE t1(c1 YEAR NOT NULL);
336
SHOW CREATE TABLE t1;
338
t1 CREATE TABLE `t1` (
339
`c1` year(4) NOT NULL
340
) ENGINE=ENGINE DEFAULT CHARSET=latin1
341
ALTER TABLE t1 ADD PRIMARY KEY (c1);
345
SHOW CREATE TABLE t1;
347
t1 CREATE TABLE `t1` (
348
`c1` year(4) NOT NULL,
350
) ENGINE=ENGINE DEFAULT CHARSET=latin1