1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1(c1 BIT NOT NULL, c2 BIT NOT NULL, c3 BIT NOT NULL);
12 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
13 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2,c3);
19 t1 CREATE TABLE `t1` (
23 PRIMARY KEY (`c1`,`c2`,`c3`)
24 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
28 CREATE TABLE t1(c1 TINYINT NOT NULL, c2 TINYINT NOT NULL, c3 TINYINT NOT NULL);
34 t1 CREATE TABLE `t1` (
35 `c1` tinyint(4) NOT NULL,
36 `c2` tinyint(4) NOT NULL,
37 `c3` tinyint(4) NOT NULL
38 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
39 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2,c3);
45 t1 CREATE TABLE `t1` (
46 `c1` tinyint(4) NOT NULL,
47 `c2` tinyint(4) NOT NULL,
48 `c3` tinyint(4) NOT NULL,
49 PRIMARY KEY (`c1`,`c2`,`c3`)
50 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
54 CREATE TABLE t1(c1 SMALLINT NOT NULL, c2 SMALLINT NOT NULL, c3 SMALLINT NOT NULL);
60 t1 CREATE TABLE `t1` (
61 `c1` smallint(6) NOT NULL,
62 `c2` smallint(6) NOT NULL,
63 `c3` smallint(6) NOT NULL
64 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
65 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2,c3);
71 t1 CREATE TABLE `t1` (
72 `c1` smallint(6) NOT NULL,
73 `c2` smallint(6) NOT NULL,
74 `c3` smallint(6) NOT NULL,
75 PRIMARY KEY (`c1`,`c2`,`c3`)
76 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
80 CREATE TABLE t1(c1 MEDIUMINT NOT NULL, c2 MEDIUMINT NOT NULL, c3 MEDIUMINT NOT NULL);
86 t1 CREATE TABLE `t1` (
87 `c1` mediumint(9) NOT NULL,
88 `c2` mediumint(9) NOT NULL,
89 `c3` mediumint(9) NOT NULL
90 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
91 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2,c3);
97 t1 CREATE TABLE `t1` (
98 `c1` mediumint(9) NOT NULL,
99 `c2` mediumint(9) NOT NULL,
100 `c3` mediumint(9) NOT NULL,
101 PRIMARY KEY (`c1`,`c2`,`c3`)
102 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
106 CREATE TABLE t1(c1 INT NOT NULL, c2 INT NOT NULL, c3 INT NOT NULL);
110 SHOW CREATE TABLE t1;
112 t1 CREATE TABLE `t1` (
113 `c1` int(11) NOT NULL,
114 `c2` int(11) NOT NULL,
115 `c3` int(11) NOT NULL
116 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
117 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2,c3);
121 SHOW CREATE TABLE t1;
123 t1 CREATE TABLE `t1` (
124 `c1` int(11) NOT NULL,
125 `c2` int(11) NOT NULL,
126 `c3` int(11) NOT NULL,
127 PRIMARY KEY (`c1`,`c2`,`c3`)
128 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
132 CREATE TABLE t1(c1 INTEGER NOT NULL, c2 INTEGER NOT NULL, c3 INTEGER NOT NULL);
136 SHOW CREATE TABLE t1;
138 t1 CREATE TABLE `t1` (
139 `c1` int(11) NOT NULL,
140 `c2` int(11) NOT NULL,
141 `c3` int(11) NOT NULL
142 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
143 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2,c3);
147 SHOW CREATE TABLE t1;
149 t1 CREATE TABLE `t1` (
150 `c1` int(11) NOT NULL,
151 `c2` int(11) NOT NULL,
152 `c3` int(11) NOT NULL,
153 PRIMARY KEY (`c1`,`c2`,`c3`)
154 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
158 CREATE TABLE t1(c1 BIGINT NOT NULL, c2 BIGINT NOT NULL, c3 BIGINT NOT NULL);
162 SHOW CREATE TABLE t1;
164 t1 CREATE TABLE `t1` (
165 `c1` bigint(20) NOT NULL,
166 `c2` bigint(20) NOT NULL,
167 `c3` bigint(20) NOT NULL
168 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
169 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2,c3);
173 SHOW CREATE TABLE t1;
175 t1 CREATE TABLE `t1` (
176 `c1` bigint(20) NOT NULL,
177 `c2` bigint(20) NOT NULL,
178 `c3` bigint(20) NOT NULL,
179 PRIMARY KEY (`c1`,`c2`,`c3`)
180 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
184 CREATE TABLE t1(c1 REAL NOT NULL, c2 REAL NOT NULL, c3 REAL NOT NULL);
188 SHOW CREATE TABLE t1;
190 t1 CREATE TABLE `t1` (
191 `c1` double NOT NULL,
192 `c2` double NOT NULL,
194 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
195 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2,c3);
199 SHOW CREATE TABLE t1;
201 t1 CREATE TABLE `t1` (
202 `c1` double NOT NULL,
203 `c2` double NOT NULL,
204 `c3` double NOT NULL,
205 PRIMARY KEY (`c1`,`c2`,`c3`)
206 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
210 CREATE TABLE t1(c1 DOUBLE NOT NULL, c2 DOUBLE NOT NULL, c3 DOUBLE NOT NULL);
214 SHOW CREATE TABLE t1;
216 t1 CREATE TABLE `t1` (
217 `c1` double NOT NULL,
218 `c2` double NOT NULL,
220 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
221 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2,c3);
225 SHOW CREATE TABLE t1;
227 t1 CREATE TABLE `t1` (
228 `c1` double NOT NULL,
229 `c2` double NOT NULL,
230 `c3` double NOT NULL,
231 PRIMARY KEY (`c1`,`c2`,`c3`)
232 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
236 CREATE TABLE t1(c1 FLOAT NOT NULL, c2 FLOAT NOT NULL, c3 FLOAT NOT NULL);
240 SHOW CREATE TABLE t1;
242 t1 CREATE TABLE `t1` (
246 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
247 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2,c3);
251 SHOW CREATE TABLE t1;
253 t1 CREATE TABLE `t1` (
257 PRIMARY KEY (`c1`,`c2`,`c3`)
258 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
262 CREATE TABLE t1(c1 DECIMAL NOT NULL, c2 DECIMAL NOT NULL, c3 DECIMAL NOT NULL);
266 SHOW CREATE TABLE t1;
268 t1 CREATE TABLE `t1` (
269 `c1` decimal(10,0) NOT NULL,
270 `c2` decimal(10,0) NOT NULL,
271 `c3` decimal(10,0) NOT NULL
272 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
273 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2,c3);
277 SHOW CREATE TABLE t1;
279 t1 CREATE TABLE `t1` (
280 `c1` decimal(10,0) NOT NULL,
281 `c2` decimal(10,0) NOT NULL,
282 `c3` decimal(10,0) NOT NULL,
283 PRIMARY KEY (`c1`,`c2`,`c3`)
284 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
288 CREATE TABLE t1(c1 NUMERIC NOT NULL, c2 NUMERIC NOT NULL, c3 NUMERIC NOT NULL);
292 SHOW CREATE TABLE t1;
294 t1 CREATE TABLE `t1` (
295 `c1` decimal(10,0) NOT NULL,
296 `c2` decimal(10,0) NOT NULL,
297 `c3` decimal(10,0) NOT NULL
298 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
299 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2,c3);
303 SHOW CREATE TABLE t1;
305 t1 CREATE TABLE `t1` (
306 `c1` decimal(10,0) NOT NULL,
307 `c2` decimal(10,0) NOT NULL,
308 `c3` decimal(10,0) NOT NULL,
309 PRIMARY KEY (`c1`,`c2`,`c3`)
310 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
314 CREATE TABLE t1(c1 DATE NOT NULL, c2 DATE NOT NULL, c3 DATE NOT NULL);
318 SHOW CREATE TABLE t1;
320 t1 CREATE TABLE `t1` (
324 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
325 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2,c3);
329 SHOW CREATE TABLE t1;
331 t1 CREATE TABLE `t1` (
335 PRIMARY KEY (`c1`,`c2`,`c3`)
336 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
340 CREATE TABLE t1(c1 TIME NOT NULL, c2 TIME NOT NULL, c3 TIME NOT NULL);
344 SHOW CREATE TABLE t1;
346 t1 CREATE TABLE `t1` (
350 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
351 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2,c3);
355 SHOW CREATE TABLE t1;
357 t1 CREATE TABLE `t1` (
361 PRIMARY KEY (`c1`,`c2`,`c3`)
362 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
366 CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 TIMESTAMP NOT NULL, c3 TIMESTAMP NOT NULL);
370 SHOW CREATE TABLE t1;
372 t1 CREATE TABLE `t1` (
373 `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
374 `c2` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
375 `c3` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
376 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
377 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2,c3);
381 SHOW CREATE TABLE t1;
383 t1 CREATE TABLE `t1` (
384 `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
385 `c2` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
386 `c3` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
387 PRIMARY KEY (`c1`,`c2`,`c3`)
388 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
392 CREATE TABLE t1(c1 YEAR NOT NULL, c2 YEAR NOT NULL, c3 YEAR NOT NULL);
396 SHOW CREATE TABLE t1;
398 t1 CREATE TABLE `t1` (
399 `c1` year(4) NOT NULL,
400 `c2` year(4) NOT NULL,
401 `c3` year(4) NOT NULL
402 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
403 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2,c3);
407 SHOW CREATE TABLE t1;
409 t1 CREATE TABLE `t1` (
410 `c1` year(4) NOT NULL,
411 `c2` year(4) NOT NULL,
412 `c3` year(4) NOT NULL,
413 PRIMARY KEY (`c1`,`c2`,`c3`)
414 ) ENGINE=ENGINE DEFAULT CHARSET=latin1