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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 KEY (c1);
345 SHOW CREATE TABLE t1;
347 t1 CREATE TABLE `t1` (
348 `c1` year(4) NOT NULL,
350 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
354 CREATE TABLE t1(c1 BIT NOT NULL);
358 SHOW CREATE TABLE t1;
360 t1 CREATE TABLE `t1` (
362 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
363 ALTER TABLE t1 ADD KEY USING BTREE (c1);
367 SHOW CREATE TABLE t1;
369 t1 CREATE TABLE `t1` (
370 `c1` bit(1) NOT NULL,
371 KEY `c1` (`c1`) USING BTREE
372 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
376 CREATE TABLE t1(c1 TINYINT NOT NULL);
380 SHOW CREATE TABLE t1;
382 t1 CREATE TABLE `t1` (
383 `c1` tinyint(4) NOT NULL
384 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
385 ALTER TABLE t1 ADD KEY USING BTREE (c1);
389 SHOW CREATE TABLE t1;
391 t1 CREATE TABLE `t1` (
392 `c1` tinyint(4) NOT NULL,
393 KEY `c1` (`c1`) USING BTREE
394 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
398 CREATE TABLE t1(c1 SMALLINT NOT NULL);
402 SHOW CREATE TABLE t1;
404 t1 CREATE TABLE `t1` (
405 `c1` smallint(6) NOT NULL
406 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
407 ALTER TABLE t1 ADD KEY USING BTREE (c1);
411 SHOW CREATE TABLE t1;
413 t1 CREATE TABLE `t1` (
414 `c1` smallint(6) NOT NULL,
415 KEY `c1` (`c1`) USING BTREE
416 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
420 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
424 SHOW CREATE TABLE t1;
426 t1 CREATE TABLE `t1` (
427 `c1` mediumint(9) NOT NULL
428 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
429 ALTER TABLE t1 ADD KEY USING BTREE (c1);
433 SHOW CREATE TABLE t1;
435 t1 CREATE TABLE `t1` (
436 `c1` mediumint(9) NOT NULL,
437 KEY `c1` (`c1`) USING BTREE
438 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
442 CREATE TABLE t1(c1 INT NOT NULL);
446 SHOW CREATE TABLE t1;
448 t1 CREATE TABLE `t1` (
449 `c1` int(11) NOT NULL
450 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
451 ALTER TABLE t1 ADD KEY USING BTREE (c1);
455 SHOW CREATE TABLE t1;
457 t1 CREATE TABLE `t1` (
458 `c1` int(11) NOT NULL,
459 KEY `c1` (`c1`) USING BTREE
460 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
464 CREATE TABLE t1(c1 INTEGER NOT NULL);
468 SHOW CREATE TABLE t1;
470 t1 CREATE TABLE `t1` (
471 `c1` int(11) NOT NULL
472 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
473 ALTER TABLE t1 ADD KEY USING BTREE (c1);
477 SHOW CREATE TABLE t1;
479 t1 CREATE TABLE `t1` (
480 `c1` int(11) NOT NULL,
481 KEY `c1` (`c1`) USING BTREE
482 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
486 CREATE TABLE t1(c1 BIGINT NOT NULL);
490 SHOW CREATE TABLE t1;
492 t1 CREATE TABLE `t1` (
493 `c1` bigint(20) NOT NULL
494 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
495 ALTER TABLE t1 ADD KEY USING BTREE (c1);
499 SHOW CREATE TABLE t1;
501 t1 CREATE TABLE `t1` (
502 `c1` bigint(20) NOT NULL,
503 KEY `c1` (`c1`) USING BTREE
504 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
508 CREATE TABLE t1(c1 REAL NOT NULL);
512 SHOW CREATE TABLE t1;
514 t1 CREATE TABLE `t1` (
516 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
517 ALTER TABLE t1 ADD KEY USING BTREE (c1);
521 SHOW CREATE TABLE t1;
523 t1 CREATE TABLE `t1` (
524 `c1` double NOT NULL,
525 KEY `c1` (`c1`) USING BTREE
526 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
530 CREATE TABLE t1(c1 DOUBLE NOT NULL);
534 SHOW CREATE TABLE t1;
536 t1 CREATE TABLE `t1` (
538 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
539 ALTER TABLE t1 ADD KEY USING BTREE (c1);
543 SHOW CREATE TABLE t1;
545 t1 CREATE TABLE `t1` (
546 `c1` double NOT NULL,
547 KEY `c1` (`c1`) USING BTREE
548 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
552 CREATE TABLE t1(c1 FLOAT NOT NULL);
556 SHOW CREATE TABLE t1;
558 t1 CREATE TABLE `t1` (
560 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
561 ALTER TABLE t1 ADD KEY USING BTREE (c1);
565 SHOW CREATE TABLE t1;
567 t1 CREATE TABLE `t1` (
569 KEY `c1` (`c1`) USING BTREE
570 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
574 CREATE TABLE t1(c1 DECIMAL NOT NULL);
578 SHOW CREATE TABLE t1;
580 t1 CREATE TABLE `t1` (
581 `c1` decimal(10,0) NOT NULL
582 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
583 ALTER TABLE t1 ADD KEY USING BTREE (c1);
587 SHOW CREATE TABLE t1;
589 t1 CREATE TABLE `t1` (
590 `c1` decimal(10,0) NOT NULL,
591 KEY `c1` (`c1`) USING BTREE
592 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
596 CREATE TABLE t1(c1 NUMERIC NOT NULL);
600 SHOW CREATE TABLE t1;
602 t1 CREATE TABLE `t1` (
603 `c1` decimal(10,0) NOT NULL
604 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
605 ALTER TABLE t1 ADD KEY USING BTREE (c1);
609 SHOW CREATE TABLE t1;
611 t1 CREATE TABLE `t1` (
612 `c1` decimal(10,0) NOT NULL,
613 KEY `c1` (`c1`) USING BTREE
614 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
618 CREATE TABLE t1(c1 DATE NOT NULL);
622 SHOW CREATE TABLE t1;
624 t1 CREATE TABLE `t1` (
626 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
627 ALTER TABLE t1 ADD KEY USING BTREE (c1);
631 SHOW CREATE TABLE t1;
633 t1 CREATE TABLE `t1` (
635 KEY `c1` (`c1`) USING BTREE
636 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
640 CREATE TABLE t1(c1 TIME NOT NULL);
644 SHOW CREATE TABLE t1;
646 t1 CREATE TABLE `t1` (
648 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
649 ALTER TABLE t1 ADD KEY USING BTREE (c1);
653 SHOW CREATE TABLE t1;
655 t1 CREATE TABLE `t1` (
657 KEY `c1` (`c1`) USING BTREE
658 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
662 CREATE TABLE t1(c1 TIMESTAMP NOT NULL);
666 SHOW CREATE TABLE t1;
668 t1 CREATE TABLE `t1` (
669 `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
670 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
671 ALTER TABLE t1 ADD KEY USING BTREE (c1);
675 SHOW CREATE TABLE t1;
677 t1 CREATE TABLE `t1` (
678 `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
679 KEY `c1` (`c1`) USING BTREE
680 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
684 CREATE TABLE t1(c1 YEAR NOT NULL);
688 SHOW CREATE TABLE t1;
690 t1 CREATE TABLE `t1` (
691 `c1` year(4) NOT NULL
692 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
693 ALTER TABLE t1 ADD KEY USING BTREE (c1);
697 SHOW CREATE TABLE t1;
699 t1 CREATE TABLE `t1` (
700 `c1` year(4) NOT NULL,
701 KEY `c1` (`c1`) USING BTREE
702 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
706 CREATE TABLE t1(c1 BIT NOT NULL);
710 SHOW CREATE TABLE t1;
712 t1 CREATE TABLE `t1` (
714 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
715 ALTER TABLE t1 ADD KEY USING HASH (c1);
719 SHOW CREATE TABLE t1;
721 t1 CREATE TABLE `t1` (
722 `c1` bit(1) NOT NULL,
723 KEY `c1` (`c1`) USING HASH
724 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
728 CREATE TABLE t1(c1 TINYINT NOT NULL);
732 SHOW CREATE TABLE t1;
734 t1 CREATE TABLE `t1` (
735 `c1` tinyint(4) NOT NULL
736 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
737 ALTER TABLE t1 ADD KEY USING HASH (c1);
741 SHOW CREATE TABLE t1;
743 t1 CREATE TABLE `t1` (
744 `c1` tinyint(4) NOT NULL,
745 KEY `c1` (`c1`) USING HASH
746 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
750 CREATE TABLE t1(c1 SMALLINT NOT NULL);
754 SHOW CREATE TABLE t1;
756 t1 CREATE TABLE `t1` (
757 `c1` smallint(6) NOT NULL
758 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
759 ALTER TABLE t1 ADD KEY USING HASH (c1);
763 SHOW CREATE TABLE t1;
765 t1 CREATE TABLE `t1` (
766 `c1` smallint(6) NOT NULL,
767 KEY `c1` (`c1`) USING HASH
768 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
772 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
776 SHOW CREATE TABLE t1;
778 t1 CREATE TABLE `t1` (
779 `c1` mediumint(9) NOT NULL
780 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
781 ALTER TABLE t1 ADD KEY USING HASH (c1);
785 SHOW CREATE TABLE t1;
787 t1 CREATE TABLE `t1` (
788 `c1` mediumint(9) NOT NULL,
789 KEY `c1` (`c1`) USING HASH
790 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
794 CREATE TABLE t1(c1 INT NOT NULL);
798 SHOW CREATE TABLE t1;
800 t1 CREATE TABLE `t1` (
801 `c1` int(11) NOT NULL
802 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
803 ALTER TABLE t1 ADD KEY USING HASH (c1);
807 SHOW CREATE TABLE t1;
809 t1 CREATE TABLE `t1` (
810 `c1` int(11) NOT NULL,
811 KEY `c1` (`c1`) USING HASH
812 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
816 CREATE TABLE t1(c1 INTEGER NOT NULL);
820 SHOW CREATE TABLE t1;
822 t1 CREATE TABLE `t1` (
823 `c1` int(11) NOT NULL
824 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
825 ALTER TABLE t1 ADD KEY USING HASH (c1);
829 SHOW CREATE TABLE t1;
831 t1 CREATE TABLE `t1` (
832 `c1` int(11) NOT NULL,
833 KEY `c1` (`c1`) USING HASH
834 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
838 CREATE TABLE t1(c1 BIGINT NOT NULL);
842 SHOW CREATE TABLE t1;
844 t1 CREATE TABLE `t1` (
845 `c1` bigint(20) NOT NULL
846 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
847 ALTER TABLE t1 ADD KEY USING HASH (c1);
851 SHOW CREATE TABLE t1;
853 t1 CREATE TABLE `t1` (
854 `c1` bigint(20) NOT NULL,
855 KEY `c1` (`c1`) USING HASH
856 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
860 CREATE TABLE t1(c1 REAL NOT NULL);
864 SHOW CREATE TABLE t1;
866 t1 CREATE TABLE `t1` (
868 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
869 ALTER TABLE t1 ADD KEY USING HASH (c1);
873 SHOW CREATE TABLE t1;
875 t1 CREATE TABLE `t1` (
876 `c1` double NOT NULL,
877 KEY `c1` (`c1`) USING HASH
878 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
882 CREATE TABLE t1(c1 DOUBLE NOT NULL);
886 SHOW CREATE TABLE t1;
888 t1 CREATE TABLE `t1` (
890 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
891 ALTER TABLE t1 ADD KEY USING HASH (c1);
895 SHOW CREATE TABLE t1;
897 t1 CREATE TABLE `t1` (
898 `c1` double NOT NULL,
899 KEY `c1` (`c1`) USING HASH
900 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
904 CREATE TABLE t1(c1 FLOAT NOT NULL);
908 SHOW CREATE TABLE t1;
910 t1 CREATE TABLE `t1` (
912 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
913 ALTER TABLE t1 ADD KEY USING HASH (c1);
917 SHOW CREATE TABLE t1;
919 t1 CREATE TABLE `t1` (
921 KEY `c1` (`c1`) USING HASH
922 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
926 CREATE TABLE t1(c1 DECIMAL NOT NULL);
930 SHOW CREATE TABLE t1;
932 t1 CREATE TABLE `t1` (
933 `c1` decimal(10,0) NOT NULL
934 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
935 ALTER TABLE t1 ADD KEY USING HASH (c1);
939 SHOW CREATE TABLE t1;
941 t1 CREATE TABLE `t1` (
942 `c1` decimal(10,0) NOT NULL,
943 KEY `c1` (`c1`) USING HASH
944 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
948 CREATE TABLE t1(c1 NUMERIC NOT NULL);
952 SHOW CREATE TABLE t1;
954 t1 CREATE TABLE `t1` (
955 `c1` decimal(10,0) NOT NULL
956 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
957 ALTER TABLE t1 ADD KEY USING HASH (c1);
961 SHOW CREATE TABLE t1;
963 t1 CREATE TABLE `t1` (
964 `c1` decimal(10,0) NOT NULL,
965 KEY `c1` (`c1`) USING HASH
966 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
970 CREATE TABLE t1(c1 DATE NOT NULL);
974 SHOW CREATE TABLE t1;
976 t1 CREATE TABLE `t1` (
978 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
979 ALTER TABLE t1 ADD KEY USING HASH (c1);
983 SHOW CREATE TABLE t1;
985 t1 CREATE TABLE `t1` (
987 KEY `c1` (`c1`) USING HASH
988 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
992 CREATE TABLE t1(c1 TIME NOT NULL);
996 SHOW CREATE TABLE t1;
998 t1 CREATE TABLE `t1` (
1000 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1001 ALTER TABLE t1 ADD KEY USING HASH (c1);
1005 SHOW CREATE TABLE t1;
1007 t1 CREATE TABLE `t1` (
1009 KEY `c1` (`c1`) USING HASH
1010 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1014 CREATE TABLE t1(c1 TIMESTAMP NOT NULL);
1018 SHOW CREATE TABLE t1;
1020 t1 CREATE TABLE `t1` (
1021 `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
1022 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1023 ALTER TABLE t1 ADD KEY USING HASH (c1);
1027 SHOW CREATE TABLE t1;
1029 t1 CREATE TABLE `t1` (
1030 `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1031 KEY `c1` (`c1`) USING HASH
1032 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1036 CREATE TABLE t1(c1 YEAR NOT NULL);
1040 SHOW CREATE TABLE t1;
1042 t1 CREATE TABLE `t1` (
1043 `c1` year(4) NOT NULL
1044 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1045 ALTER TABLE t1 ADD KEY USING HASH (c1);
1049 SHOW CREATE TABLE t1;
1051 t1 CREATE TABLE `t1` (
1052 `c1` year(4) NOT NULL,
1053 KEY `c1` (`c1`) USING HASH
1054 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1058 CREATE TABLE t1(c1 BIT NOT NULL);
1062 SHOW CREATE TABLE t1;
1064 t1 CREATE TABLE `t1` (
1065 `c1` bit(1) NOT NULL
1066 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1067 ALTER TABLE t1 ADD INDEX (c1);
1071 SHOW CREATE TABLE t1;
1073 t1 CREATE TABLE `t1` (
1074 `c1` bit(1) NOT NULL,
1076 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1080 CREATE TABLE t1(c1 TINYINT NOT NULL);
1084 SHOW CREATE TABLE t1;
1086 t1 CREATE TABLE `t1` (
1087 `c1` tinyint(4) NOT NULL
1088 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1089 ALTER TABLE t1 ADD INDEX (c1);
1093 SHOW CREATE TABLE t1;
1095 t1 CREATE TABLE `t1` (
1096 `c1` tinyint(4) NOT NULL,
1098 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1102 CREATE TABLE t1(c1 SMALLINT NOT NULL);
1106 SHOW CREATE TABLE t1;
1108 t1 CREATE TABLE `t1` (
1109 `c1` smallint(6) NOT NULL
1110 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1111 ALTER TABLE t1 ADD INDEX (c1);
1115 SHOW CREATE TABLE t1;
1117 t1 CREATE TABLE `t1` (
1118 `c1` smallint(6) NOT NULL,
1120 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1124 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
1128 SHOW CREATE TABLE t1;
1130 t1 CREATE TABLE `t1` (
1131 `c1` mediumint(9) NOT NULL
1132 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1133 ALTER TABLE t1 ADD INDEX (c1);
1137 SHOW CREATE TABLE t1;
1139 t1 CREATE TABLE `t1` (
1140 `c1` mediumint(9) NOT NULL,
1142 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1146 CREATE TABLE t1(c1 INT NOT NULL);
1150 SHOW CREATE TABLE t1;
1152 t1 CREATE TABLE `t1` (
1153 `c1` int(11) NOT NULL
1154 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1155 ALTER TABLE t1 ADD INDEX (c1);
1159 SHOW CREATE TABLE t1;
1161 t1 CREATE TABLE `t1` (
1162 `c1` int(11) NOT NULL,
1164 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1168 CREATE TABLE t1(c1 INTEGER NOT NULL);
1172 SHOW CREATE TABLE t1;
1174 t1 CREATE TABLE `t1` (
1175 `c1` int(11) NOT NULL
1176 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1177 ALTER TABLE t1 ADD INDEX (c1);
1181 SHOW CREATE TABLE t1;
1183 t1 CREATE TABLE `t1` (
1184 `c1` int(11) NOT NULL,
1186 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1190 CREATE TABLE t1(c1 BIGINT NOT NULL);
1194 SHOW CREATE TABLE t1;
1196 t1 CREATE TABLE `t1` (
1197 `c1` bigint(20) NOT NULL
1198 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1199 ALTER TABLE t1 ADD INDEX (c1);
1203 SHOW CREATE TABLE t1;
1205 t1 CREATE TABLE `t1` (
1206 `c1` bigint(20) NOT NULL,
1208 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1212 CREATE TABLE t1(c1 REAL NOT NULL);
1216 SHOW CREATE TABLE t1;
1218 t1 CREATE TABLE `t1` (
1219 `c1` double NOT NULL
1220 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1221 ALTER TABLE t1 ADD INDEX (c1);
1225 SHOW CREATE TABLE t1;
1227 t1 CREATE TABLE `t1` (
1228 `c1` double NOT NULL,
1230 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1234 CREATE TABLE t1(c1 DOUBLE NOT NULL);
1238 SHOW CREATE TABLE t1;
1240 t1 CREATE TABLE `t1` (
1241 `c1` double NOT NULL
1242 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1243 ALTER TABLE t1 ADD INDEX (c1);
1247 SHOW CREATE TABLE t1;
1249 t1 CREATE TABLE `t1` (
1250 `c1` double NOT NULL,
1252 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1256 CREATE TABLE t1(c1 FLOAT NOT NULL);
1260 SHOW CREATE TABLE t1;
1262 t1 CREATE TABLE `t1` (
1264 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1265 ALTER TABLE t1 ADD INDEX (c1);
1269 SHOW CREATE TABLE t1;
1271 t1 CREATE TABLE `t1` (
1272 `c1` float NOT NULL,
1274 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1278 CREATE TABLE t1(c1 DECIMAL NOT NULL);
1282 SHOW CREATE TABLE t1;
1284 t1 CREATE TABLE `t1` (
1285 `c1` decimal(10,0) NOT NULL
1286 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1287 ALTER TABLE t1 ADD INDEX (c1);
1291 SHOW CREATE TABLE t1;
1293 t1 CREATE TABLE `t1` (
1294 `c1` decimal(10,0) NOT NULL,
1296 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1300 CREATE TABLE t1(c1 NUMERIC NOT NULL);
1304 SHOW CREATE TABLE t1;
1306 t1 CREATE TABLE `t1` (
1307 `c1` decimal(10,0) NOT NULL
1308 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1309 ALTER TABLE t1 ADD INDEX (c1);
1313 SHOW CREATE TABLE t1;
1315 t1 CREATE TABLE `t1` (
1316 `c1` decimal(10,0) NOT NULL,
1318 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1322 CREATE TABLE t1(c1 DATE NOT NULL);
1326 SHOW CREATE TABLE t1;
1328 t1 CREATE TABLE `t1` (
1330 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1331 ALTER TABLE t1 ADD INDEX (c1);
1335 SHOW CREATE TABLE t1;
1337 t1 CREATE TABLE `t1` (
1340 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1344 CREATE TABLE t1(c1 TIME NOT NULL);
1348 SHOW CREATE TABLE t1;
1350 t1 CREATE TABLE `t1` (
1352 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1353 ALTER TABLE t1 ADD INDEX (c1);
1357 SHOW CREATE TABLE t1;
1359 t1 CREATE TABLE `t1` (
1362 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1366 CREATE TABLE t1(c1 TIMESTAMP NOT NULL);
1370 SHOW CREATE TABLE t1;
1372 t1 CREATE TABLE `t1` (
1373 `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
1374 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1375 ALTER TABLE t1 ADD INDEX (c1);
1379 SHOW CREATE TABLE t1;
1381 t1 CREATE TABLE `t1` (
1382 `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1384 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1388 CREATE TABLE t1(c1 YEAR NOT NULL);
1392 SHOW CREATE TABLE t1;
1394 t1 CREATE TABLE `t1` (
1395 `c1` year(4) NOT NULL
1396 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1397 ALTER TABLE t1 ADD INDEX (c1);
1401 SHOW CREATE TABLE t1;
1403 t1 CREATE TABLE `t1` (
1404 `c1` year(4) NOT NULL,
1406 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1410 CREATE TABLE t1(c1 BIT NOT NULL);
1414 SHOW CREATE TABLE t1;
1416 t1 CREATE TABLE `t1` (
1417 `c1` bit(1) NOT NULL
1418 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1419 ALTER TABLE t1 ADD INDEX USING BTREE (c1);
1423 SHOW CREATE TABLE t1;
1425 t1 CREATE TABLE `t1` (
1426 `c1` bit(1) NOT NULL,
1427 KEY `c1` (`c1`) USING BTREE
1428 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1432 CREATE TABLE t1(c1 TINYINT NOT NULL);
1436 SHOW CREATE TABLE t1;
1438 t1 CREATE TABLE `t1` (
1439 `c1` tinyint(4) NOT NULL
1440 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1441 ALTER TABLE t1 ADD INDEX USING BTREE (c1);
1445 SHOW CREATE TABLE t1;
1447 t1 CREATE TABLE `t1` (
1448 `c1` tinyint(4) NOT NULL,
1449 KEY `c1` (`c1`) USING BTREE
1450 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1454 CREATE TABLE t1(c1 SMALLINT NOT NULL);
1458 SHOW CREATE TABLE t1;
1460 t1 CREATE TABLE `t1` (
1461 `c1` smallint(6) NOT NULL
1462 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1463 ALTER TABLE t1 ADD INDEX USING BTREE (c1);
1467 SHOW CREATE TABLE t1;
1469 t1 CREATE TABLE `t1` (
1470 `c1` smallint(6) NOT NULL,
1471 KEY `c1` (`c1`) USING BTREE
1472 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1476 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
1480 SHOW CREATE TABLE t1;
1482 t1 CREATE TABLE `t1` (
1483 `c1` mediumint(9) NOT NULL
1484 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1485 ALTER TABLE t1 ADD INDEX USING BTREE (c1);
1489 SHOW CREATE TABLE t1;
1491 t1 CREATE TABLE `t1` (
1492 `c1` mediumint(9) NOT NULL,
1493 KEY `c1` (`c1`) USING BTREE
1494 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1498 CREATE TABLE t1(c1 INT NOT NULL);
1502 SHOW CREATE TABLE t1;
1504 t1 CREATE TABLE `t1` (
1505 `c1` int(11) NOT NULL
1506 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1507 ALTER TABLE t1 ADD INDEX USING BTREE (c1);
1511 SHOW CREATE TABLE t1;
1513 t1 CREATE TABLE `t1` (
1514 `c1` int(11) NOT NULL,
1515 KEY `c1` (`c1`) USING BTREE
1516 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1520 CREATE TABLE t1(c1 INTEGER NOT NULL);
1524 SHOW CREATE TABLE t1;
1526 t1 CREATE TABLE `t1` (
1527 `c1` int(11) NOT NULL
1528 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1529 ALTER TABLE t1 ADD INDEX USING BTREE (c1);
1533 SHOW CREATE TABLE t1;
1535 t1 CREATE TABLE `t1` (
1536 `c1` int(11) NOT NULL,
1537 KEY `c1` (`c1`) USING BTREE
1538 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1542 CREATE TABLE t1(c1 BIGINT NOT NULL);
1546 SHOW CREATE TABLE t1;
1548 t1 CREATE TABLE `t1` (
1549 `c1` bigint(20) NOT NULL
1550 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1551 ALTER TABLE t1 ADD INDEX USING BTREE (c1);
1555 SHOW CREATE TABLE t1;
1557 t1 CREATE TABLE `t1` (
1558 `c1` bigint(20) NOT NULL,
1559 KEY `c1` (`c1`) USING BTREE
1560 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1564 CREATE TABLE t1(c1 REAL NOT NULL);
1568 SHOW CREATE TABLE t1;
1570 t1 CREATE TABLE `t1` (
1571 `c1` double NOT NULL
1572 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1573 ALTER TABLE t1 ADD INDEX USING BTREE (c1);
1577 SHOW CREATE TABLE t1;
1579 t1 CREATE TABLE `t1` (
1580 `c1` double NOT NULL,
1581 KEY `c1` (`c1`) USING BTREE
1582 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1586 CREATE TABLE t1(c1 DOUBLE NOT NULL);
1590 SHOW CREATE TABLE t1;
1592 t1 CREATE TABLE `t1` (
1593 `c1` double NOT NULL
1594 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1595 ALTER TABLE t1 ADD INDEX USING BTREE (c1);
1599 SHOW CREATE TABLE t1;
1601 t1 CREATE TABLE `t1` (
1602 `c1` double NOT NULL,
1603 KEY `c1` (`c1`) USING BTREE
1604 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1608 CREATE TABLE t1(c1 FLOAT NOT NULL);
1612 SHOW CREATE TABLE t1;
1614 t1 CREATE TABLE `t1` (
1616 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1617 ALTER TABLE t1 ADD INDEX USING BTREE (c1);
1621 SHOW CREATE TABLE t1;
1623 t1 CREATE TABLE `t1` (
1624 `c1` float NOT NULL,
1625 KEY `c1` (`c1`) USING BTREE
1626 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1630 CREATE TABLE t1(c1 DECIMAL NOT NULL);
1634 SHOW CREATE TABLE t1;
1636 t1 CREATE TABLE `t1` (
1637 `c1` decimal(10,0) NOT NULL
1638 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1639 ALTER TABLE t1 ADD INDEX USING BTREE (c1);
1643 SHOW CREATE TABLE t1;
1645 t1 CREATE TABLE `t1` (
1646 `c1` decimal(10,0) NOT NULL,
1647 KEY `c1` (`c1`) USING BTREE
1648 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1652 CREATE TABLE t1(c1 NUMERIC NOT NULL);
1656 SHOW CREATE TABLE t1;
1658 t1 CREATE TABLE `t1` (
1659 `c1` decimal(10,0) NOT NULL
1660 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1661 ALTER TABLE t1 ADD INDEX USING BTREE (c1);
1665 SHOW CREATE TABLE t1;
1667 t1 CREATE TABLE `t1` (
1668 `c1` decimal(10,0) NOT NULL,
1669 KEY `c1` (`c1`) USING BTREE
1670 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1674 CREATE TABLE t1(c1 DATE NOT NULL);
1678 SHOW CREATE TABLE t1;
1680 t1 CREATE TABLE `t1` (
1682 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1683 ALTER TABLE t1 ADD INDEX USING BTREE (c1);
1687 SHOW CREATE TABLE t1;
1689 t1 CREATE TABLE `t1` (
1691 KEY `c1` (`c1`) USING BTREE
1692 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1696 CREATE TABLE t1(c1 TIME NOT NULL);
1700 SHOW CREATE TABLE t1;
1702 t1 CREATE TABLE `t1` (
1704 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1705 ALTER TABLE t1 ADD INDEX USING BTREE (c1);
1709 SHOW CREATE TABLE t1;
1711 t1 CREATE TABLE `t1` (
1713 KEY `c1` (`c1`) USING BTREE
1714 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1718 CREATE TABLE t1(c1 TIMESTAMP NOT NULL);
1722 SHOW CREATE TABLE t1;
1724 t1 CREATE TABLE `t1` (
1725 `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
1726 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1727 ALTER TABLE t1 ADD INDEX USING BTREE (c1);
1731 SHOW CREATE TABLE t1;
1733 t1 CREATE TABLE `t1` (
1734 `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1735 KEY `c1` (`c1`) USING BTREE
1736 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1740 CREATE TABLE t1(c1 YEAR NOT NULL);
1744 SHOW CREATE TABLE t1;
1746 t1 CREATE TABLE `t1` (
1747 `c1` year(4) NOT NULL
1748 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1749 ALTER TABLE t1 ADD INDEX USING BTREE (c1);
1753 SHOW CREATE TABLE t1;
1755 t1 CREATE TABLE `t1` (
1756 `c1` year(4) NOT NULL,
1757 KEY `c1` (`c1`) USING BTREE
1758 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1762 CREATE TABLE t1(c1 BIT NOT NULL);
1766 SHOW CREATE TABLE t1;
1768 t1 CREATE TABLE `t1` (
1769 `c1` bit(1) NOT NULL
1770 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1771 ALTER TABLE t1 ADD INDEX USING HASH (c1);
1775 SHOW CREATE TABLE t1;
1777 t1 CREATE TABLE `t1` (
1778 `c1` bit(1) NOT NULL,
1779 KEY `c1` (`c1`) USING HASH
1780 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1784 CREATE TABLE t1(c1 TINYINT NOT NULL);
1788 SHOW CREATE TABLE t1;
1790 t1 CREATE TABLE `t1` (
1791 `c1` tinyint(4) NOT NULL
1792 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1793 ALTER TABLE t1 ADD INDEX USING HASH (c1);
1797 SHOW CREATE TABLE t1;
1799 t1 CREATE TABLE `t1` (
1800 `c1` tinyint(4) NOT NULL,
1801 KEY `c1` (`c1`) USING HASH
1802 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1806 CREATE TABLE t1(c1 SMALLINT NOT NULL);
1810 SHOW CREATE TABLE t1;
1812 t1 CREATE TABLE `t1` (
1813 `c1` smallint(6) NOT NULL
1814 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1815 ALTER TABLE t1 ADD INDEX USING HASH (c1);
1819 SHOW CREATE TABLE t1;
1821 t1 CREATE TABLE `t1` (
1822 `c1` smallint(6) NOT NULL,
1823 KEY `c1` (`c1`) USING HASH
1824 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1828 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
1832 SHOW CREATE TABLE t1;
1834 t1 CREATE TABLE `t1` (
1835 `c1` mediumint(9) NOT NULL
1836 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1837 ALTER TABLE t1 ADD INDEX USING HASH (c1);
1841 SHOW CREATE TABLE t1;
1843 t1 CREATE TABLE `t1` (
1844 `c1` mediumint(9) NOT NULL,
1845 KEY `c1` (`c1`) USING HASH
1846 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1850 CREATE TABLE t1(c1 INT NOT NULL);
1854 SHOW CREATE TABLE t1;
1856 t1 CREATE TABLE `t1` (
1857 `c1` int(11) NOT NULL
1858 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1859 ALTER TABLE t1 ADD INDEX USING HASH (c1);
1863 SHOW CREATE TABLE t1;
1865 t1 CREATE TABLE `t1` (
1866 `c1` int(11) NOT NULL,
1867 KEY `c1` (`c1`) USING HASH
1868 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1872 CREATE TABLE t1(c1 INTEGER NOT NULL);
1876 SHOW CREATE TABLE t1;
1878 t1 CREATE TABLE `t1` (
1879 `c1` int(11) NOT NULL
1880 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1881 ALTER TABLE t1 ADD INDEX USING HASH (c1);
1885 SHOW CREATE TABLE t1;
1887 t1 CREATE TABLE `t1` (
1888 `c1` int(11) NOT NULL,
1889 KEY `c1` (`c1`) USING HASH
1890 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1894 CREATE TABLE t1(c1 BIGINT NOT NULL);
1898 SHOW CREATE TABLE t1;
1900 t1 CREATE TABLE `t1` (
1901 `c1` bigint(20) NOT NULL
1902 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1903 ALTER TABLE t1 ADD INDEX USING HASH (c1);
1907 SHOW CREATE TABLE t1;
1909 t1 CREATE TABLE `t1` (
1910 `c1` bigint(20) NOT NULL,
1911 KEY `c1` (`c1`) USING HASH
1912 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1916 CREATE TABLE t1(c1 REAL NOT NULL);
1920 SHOW CREATE TABLE t1;
1922 t1 CREATE TABLE `t1` (
1923 `c1` double NOT NULL
1924 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1925 ALTER TABLE t1 ADD INDEX USING HASH (c1);
1929 SHOW CREATE TABLE t1;
1931 t1 CREATE TABLE `t1` (
1932 `c1` double NOT NULL,
1933 KEY `c1` (`c1`) USING HASH
1934 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1938 CREATE TABLE t1(c1 DOUBLE NOT NULL);
1942 SHOW CREATE TABLE t1;
1944 t1 CREATE TABLE `t1` (
1945 `c1` double NOT NULL
1946 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1947 ALTER TABLE t1 ADD INDEX USING HASH (c1);
1951 SHOW CREATE TABLE t1;
1953 t1 CREATE TABLE `t1` (
1954 `c1` double NOT NULL,
1955 KEY `c1` (`c1`) USING HASH
1956 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1960 CREATE TABLE t1(c1 FLOAT NOT NULL);
1964 SHOW CREATE TABLE t1;
1966 t1 CREATE TABLE `t1` (
1968 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1969 ALTER TABLE t1 ADD INDEX USING HASH (c1);
1973 SHOW CREATE TABLE t1;
1975 t1 CREATE TABLE `t1` (
1976 `c1` float NOT NULL,
1977 KEY `c1` (`c1`) USING HASH
1978 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1982 CREATE TABLE t1(c1 DECIMAL NOT NULL);
1986 SHOW CREATE TABLE t1;
1988 t1 CREATE TABLE `t1` (
1989 `c1` decimal(10,0) NOT NULL
1990 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
1991 ALTER TABLE t1 ADD INDEX USING HASH (c1);
1995 SHOW CREATE TABLE t1;
1997 t1 CREATE TABLE `t1` (
1998 `c1` decimal(10,0) NOT NULL,
1999 KEY `c1` (`c1`) USING HASH
2000 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2004 CREATE TABLE t1(c1 NUMERIC NOT NULL);
2008 SHOW CREATE TABLE t1;
2010 t1 CREATE TABLE `t1` (
2011 `c1` decimal(10,0) NOT NULL
2012 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2013 ALTER TABLE t1 ADD INDEX USING HASH (c1);
2017 SHOW CREATE TABLE t1;
2019 t1 CREATE TABLE `t1` (
2020 `c1` decimal(10,0) NOT NULL,
2021 KEY `c1` (`c1`) USING HASH
2022 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2026 CREATE TABLE t1(c1 DATE NOT NULL);
2030 SHOW CREATE TABLE t1;
2032 t1 CREATE TABLE `t1` (
2034 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2035 ALTER TABLE t1 ADD INDEX USING HASH (c1);
2039 SHOW CREATE TABLE t1;
2041 t1 CREATE TABLE `t1` (
2043 KEY `c1` (`c1`) USING HASH
2044 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2048 CREATE TABLE t1(c1 TIME NOT NULL);
2052 SHOW CREATE TABLE t1;
2054 t1 CREATE TABLE `t1` (
2056 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2057 ALTER TABLE t1 ADD INDEX USING HASH (c1);
2061 SHOW CREATE TABLE t1;
2063 t1 CREATE TABLE `t1` (
2065 KEY `c1` (`c1`) USING HASH
2066 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2070 CREATE TABLE t1(c1 TIMESTAMP NOT NULL);
2074 SHOW CREATE TABLE t1;
2076 t1 CREATE TABLE `t1` (
2077 `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
2078 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2079 ALTER TABLE t1 ADD INDEX USING HASH (c1);
2083 SHOW CREATE TABLE t1;
2085 t1 CREATE TABLE `t1` (
2086 `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
2087 KEY `c1` (`c1`) USING HASH
2088 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2092 CREATE TABLE t1(c1 YEAR NOT NULL);
2096 SHOW CREATE TABLE t1;
2098 t1 CREATE TABLE `t1` (
2099 `c1` year(4) NOT NULL
2100 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2101 ALTER TABLE t1 ADD INDEX USING HASH (c1);
2105 SHOW CREATE TABLE t1;
2107 t1 CREATE TABLE `t1` (
2108 `c1` year(4) NOT NULL,
2109 KEY `c1` (`c1`) USING HASH
2110 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2114 CREATE TABLE t1(c1 BIT NOT NULL);
2118 SHOW CREATE TABLE t1;
2120 t1 CREATE TABLE `t1` (
2121 `c1` bit(1) NOT NULL
2122 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2123 ALTER TABLE t1 ADD KEY i1 (c1);
2127 SHOW CREATE TABLE t1;
2129 t1 CREATE TABLE `t1` (
2130 `c1` bit(1) NOT NULL,
2132 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2136 CREATE TABLE t1(c1 TINYINT NOT NULL);
2140 SHOW CREATE TABLE t1;
2142 t1 CREATE TABLE `t1` (
2143 `c1` tinyint(4) NOT NULL
2144 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2145 ALTER TABLE t1 ADD KEY i1 (c1);
2149 SHOW CREATE TABLE t1;
2151 t1 CREATE TABLE `t1` (
2152 `c1` tinyint(4) NOT NULL,
2154 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2158 CREATE TABLE t1(c1 SMALLINT NOT NULL);
2162 SHOW CREATE TABLE t1;
2164 t1 CREATE TABLE `t1` (
2165 `c1` smallint(6) NOT NULL
2166 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2167 ALTER TABLE t1 ADD KEY i1 (c1);
2171 SHOW CREATE TABLE t1;
2173 t1 CREATE TABLE `t1` (
2174 `c1` smallint(6) NOT NULL,
2176 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2180 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
2184 SHOW CREATE TABLE t1;
2186 t1 CREATE TABLE `t1` (
2187 `c1` mediumint(9) NOT NULL
2188 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2189 ALTER TABLE t1 ADD KEY i1 (c1);
2193 SHOW CREATE TABLE t1;
2195 t1 CREATE TABLE `t1` (
2196 `c1` mediumint(9) NOT NULL,
2198 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2202 CREATE TABLE t1(c1 INT NOT NULL);
2206 SHOW CREATE TABLE t1;
2208 t1 CREATE TABLE `t1` (
2209 `c1` int(11) NOT NULL
2210 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2211 ALTER TABLE t1 ADD KEY i1 (c1);
2215 SHOW CREATE TABLE t1;
2217 t1 CREATE TABLE `t1` (
2218 `c1` int(11) NOT NULL,
2220 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2224 CREATE TABLE t1(c1 INTEGER NOT NULL);
2228 SHOW CREATE TABLE t1;
2230 t1 CREATE TABLE `t1` (
2231 `c1` int(11) NOT NULL
2232 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2233 ALTER TABLE t1 ADD KEY i1 (c1);
2237 SHOW CREATE TABLE t1;
2239 t1 CREATE TABLE `t1` (
2240 `c1` int(11) NOT NULL,
2242 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2246 CREATE TABLE t1(c1 BIGINT NOT NULL);
2250 SHOW CREATE TABLE t1;
2252 t1 CREATE TABLE `t1` (
2253 `c1` bigint(20) NOT NULL
2254 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2255 ALTER TABLE t1 ADD KEY i1 (c1);
2259 SHOW CREATE TABLE t1;
2261 t1 CREATE TABLE `t1` (
2262 `c1` bigint(20) NOT NULL,
2264 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2268 CREATE TABLE t1(c1 REAL NOT NULL);
2272 SHOW CREATE TABLE t1;
2274 t1 CREATE TABLE `t1` (
2275 `c1` double NOT NULL
2276 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2277 ALTER TABLE t1 ADD KEY i1 (c1);
2281 SHOW CREATE TABLE t1;
2283 t1 CREATE TABLE `t1` (
2284 `c1` double NOT NULL,
2286 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2290 CREATE TABLE t1(c1 DOUBLE NOT NULL);
2294 SHOW CREATE TABLE t1;
2296 t1 CREATE TABLE `t1` (
2297 `c1` double NOT NULL
2298 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2299 ALTER TABLE t1 ADD KEY i1 (c1);
2303 SHOW CREATE TABLE t1;
2305 t1 CREATE TABLE `t1` (
2306 `c1` double NOT NULL,
2308 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2312 CREATE TABLE t1(c1 FLOAT NOT NULL);
2316 SHOW CREATE TABLE t1;
2318 t1 CREATE TABLE `t1` (
2320 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2321 ALTER TABLE t1 ADD KEY i1 (c1);
2325 SHOW CREATE TABLE t1;
2327 t1 CREATE TABLE `t1` (
2328 `c1` float NOT NULL,
2330 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2334 CREATE TABLE t1(c1 DECIMAL NOT NULL);
2338 SHOW CREATE TABLE t1;
2340 t1 CREATE TABLE `t1` (
2341 `c1` decimal(10,0) NOT NULL
2342 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2343 ALTER TABLE t1 ADD KEY i1 (c1);
2347 SHOW CREATE TABLE t1;
2349 t1 CREATE TABLE `t1` (
2350 `c1` decimal(10,0) NOT NULL,
2352 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2356 CREATE TABLE t1(c1 NUMERIC NOT NULL);
2360 SHOW CREATE TABLE t1;
2362 t1 CREATE TABLE `t1` (
2363 `c1` decimal(10,0) NOT NULL
2364 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2365 ALTER TABLE t1 ADD KEY i1 (c1);
2369 SHOW CREATE TABLE t1;
2371 t1 CREATE TABLE `t1` (
2372 `c1` decimal(10,0) NOT NULL,
2374 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2378 CREATE TABLE t1(c1 DATE NOT NULL);
2382 SHOW CREATE TABLE t1;
2384 t1 CREATE TABLE `t1` (
2386 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2387 ALTER TABLE t1 ADD KEY i1 (c1);
2391 SHOW CREATE TABLE t1;
2393 t1 CREATE TABLE `t1` (
2396 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2400 CREATE TABLE t1(c1 TIME NOT NULL);
2404 SHOW CREATE TABLE t1;
2406 t1 CREATE TABLE `t1` (
2408 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2409 ALTER TABLE t1 ADD KEY i1 (c1);
2413 SHOW CREATE TABLE t1;
2415 t1 CREATE TABLE `t1` (
2418 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2422 CREATE TABLE t1(c1 TIMESTAMP NOT NULL);
2426 SHOW CREATE TABLE t1;
2428 t1 CREATE TABLE `t1` (
2429 `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
2430 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2431 ALTER TABLE t1 ADD KEY i1 (c1);
2435 SHOW CREATE TABLE t1;
2437 t1 CREATE TABLE `t1` (
2438 `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
2440 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2444 CREATE TABLE t1(c1 YEAR NOT NULL);
2448 SHOW CREATE TABLE t1;
2450 t1 CREATE TABLE `t1` (
2451 `c1` year(4) NOT NULL
2452 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2453 ALTER TABLE t1 ADD KEY i1 (c1);
2457 SHOW CREATE TABLE t1;
2459 t1 CREATE TABLE `t1` (
2460 `c1` year(4) NOT NULL,
2462 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2466 CREATE TABLE t1(c1 BIT NOT NULL);
2470 SHOW CREATE TABLE t1;
2472 t1 CREATE TABLE `t1` (
2473 `c1` bit(1) NOT NULL
2474 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2475 ALTER TABLE t1 ADD KEY i1 USING BTREE (c1);
2479 SHOW CREATE TABLE t1;
2481 t1 CREATE TABLE `t1` (
2482 `c1` bit(1) NOT NULL,
2483 KEY `i1` (`c1`) USING BTREE
2484 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2488 CREATE TABLE t1(c1 TINYINT NOT NULL);
2492 SHOW CREATE TABLE t1;
2494 t1 CREATE TABLE `t1` (
2495 `c1` tinyint(4) NOT NULL
2496 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2497 ALTER TABLE t1 ADD KEY i1 USING BTREE (c1);
2501 SHOW CREATE TABLE t1;
2503 t1 CREATE TABLE `t1` (
2504 `c1` tinyint(4) NOT NULL,
2505 KEY `i1` (`c1`) USING BTREE
2506 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2510 CREATE TABLE t1(c1 SMALLINT NOT NULL);
2514 SHOW CREATE TABLE t1;
2516 t1 CREATE TABLE `t1` (
2517 `c1` smallint(6) NOT NULL
2518 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2519 ALTER TABLE t1 ADD KEY i1 USING BTREE (c1);
2523 SHOW CREATE TABLE t1;
2525 t1 CREATE TABLE `t1` (
2526 `c1` smallint(6) NOT NULL,
2527 KEY `i1` (`c1`) USING BTREE
2528 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2532 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
2536 SHOW CREATE TABLE t1;
2538 t1 CREATE TABLE `t1` (
2539 `c1` mediumint(9) NOT NULL
2540 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2541 ALTER TABLE t1 ADD KEY i1 USING BTREE (c1);
2545 SHOW CREATE TABLE t1;
2547 t1 CREATE TABLE `t1` (
2548 `c1` mediumint(9) NOT NULL,
2549 KEY `i1` (`c1`) USING BTREE
2550 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2554 CREATE TABLE t1(c1 INT NOT NULL);
2558 SHOW CREATE TABLE t1;
2560 t1 CREATE TABLE `t1` (
2561 `c1` int(11) NOT NULL
2562 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2563 ALTER TABLE t1 ADD KEY i1 USING BTREE (c1);
2567 SHOW CREATE TABLE t1;
2569 t1 CREATE TABLE `t1` (
2570 `c1` int(11) NOT NULL,
2571 KEY `i1` (`c1`) USING BTREE
2572 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2576 CREATE TABLE t1(c1 INTEGER NOT NULL);
2580 SHOW CREATE TABLE t1;
2582 t1 CREATE TABLE `t1` (
2583 `c1` int(11) NOT NULL
2584 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2585 ALTER TABLE t1 ADD KEY i1 USING BTREE (c1);
2589 SHOW CREATE TABLE t1;
2591 t1 CREATE TABLE `t1` (
2592 `c1` int(11) NOT NULL,
2593 KEY `i1` (`c1`) USING BTREE
2594 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2598 CREATE TABLE t1(c1 BIGINT NOT NULL);
2602 SHOW CREATE TABLE t1;
2604 t1 CREATE TABLE `t1` (
2605 `c1` bigint(20) NOT NULL
2606 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2607 ALTER TABLE t1 ADD KEY i1 USING BTREE (c1);
2611 SHOW CREATE TABLE t1;
2613 t1 CREATE TABLE `t1` (
2614 `c1` bigint(20) NOT NULL,
2615 KEY `i1` (`c1`) USING BTREE
2616 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2620 CREATE TABLE t1(c1 REAL NOT NULL);
2624 SHOW CREATE TABLE t1;
2626 t1 CREATE TABLE `t1` (
2627 `c1` double NOT NULL
2628 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2629 ALTER TABLE t1 ADD KEY i1 USING BTREE (c1);
2633 SHOW CREATE TABLE t1;
2635 t1 CREATE TABLE `t1` (
2636 `c1` double NOT NULL,
2637 KEY `i1` (`c1`) USING BTREE
2638 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2642 CREATE TABLE t1(c1 DOUBLE NOT NULL);
2646 SHOW CREATE TABLE t1;
2648 t1 CREATE TABLE `t1` (
2649 `c1` double NOT NULL
2650 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2651 ALTER TABLE t1 ADD KEY i1 USING BTREE (c1);
2655 SHOW CREATE TABLE t1;
2657 t1 CREATE TABLE `t1` (
2658 `c1` double NOT NULL,
2659 KEY `i1` (`c1`) USING BTREE
2660 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2664 CREATE TABLE t1(c1 FLOAT NOT NULL);
2668 SHOW CREATE TABLE t1;
2670 t1 CREATE TABLE `t1` (
2672 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2673 ALTER TABLE t1 ADD KEY i1 USING BTREE (c1);
2677 SHOW CREATE TABLE t1;
2679 t1 CREATE TABLE `t1` (
2680 `c1` float NOT NULL,
2681 KEY `i1` (`c1`) USING BTREE
2682 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2686 CREATE TABLE t1(c1 DECIMAL NOT NULL);
2690 SHOW CREATE TABLE t1;
2692 t1 CREATE TABLE `t1` (
2693 `c1` decimal(10,0) NOT NULL
2694 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2695 ALTER TABLE t1 ADD KEY i1 USING BTREE (c1);
2699 SHOW CREATE TABLE t1;
2701 t1 CREATE TABLE `t1` (
2702 `c1` decimal(10,0) NOT NULL,
2703 KEY `i1` (`c1`) USING BTREE
2704 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2708 CREATE TABLE t1(c1 NUMERIC NOT NULL);
2712 SHOW CREATE TABLE t1;
2714 t1 CREATE TABLE `t1` (
2715 `c1` decimal(10,0) NOT NULL
2716 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2717 ALTER TABLE t1 ADD KEY i1 USING BTREE (c1);
2721 SHOW CREATE TABLE t1;
2723 t1 CREATE TABLE `t1` (
2724 `c1` decimal(10,0) NOT NULL,
2725 KEY `i1` (`c1`) USING BTREE
2726 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2730 CREATE TABLE t1(c1 DATE NOT NULL);
2734 SHOW CREATE TABLE t1;
2736 t1 CREATE TABLE `t1` (
2738 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2739 ALTER TABLE t1 ADD KEY i1 USING BTREE (c1);
2743 SHOW CREATE TABLE t1;
2745 t1 CREATE TABLE `t1` (
2747 KEY `i1` (`c1`) USING BTREE
2748 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2752 CREATE TABLE t1(c1 TIME NOT NULL);
2756 SHOW CREATE TABLE t1;
2758 t1 CREATE TABLE `t1` (
2760 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2761 ALTER TABLE t1 ADD KEY i1 USING BTREE (c1);
2765 SHOW CREATE TABLE t1;
2767 t1 CREATE TABLE `t1` (
2769 KEY `i1` (`c1`) USING BTREE
2770 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2774 CREATE TABLE t1(c1 TIMESTAMP NOT NULL);
2778 SHOW CREATE TABLE t1;
2780 t1 CREATE TABLE `t1` (
2781 `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
2782 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2783 ALTER TABLE t1 ADD KEY i1 USING BTREE (c1);
2787 SHOW CREATE TABLE t1;
2789 t1 CREATE TABLE `t1` (
2790 `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
2791 KEY `i1` (`c1`) USING BTREE
2792 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2796 CREATE TABLE t1(c1 YEAR NOT NULL);
2800 SHOW CREATE TABLE t1;
2802 t1 CREATE TABLE `t1` (
2803 `c1` year(4) NOT NULL
2804 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2805 ALTER TABLE t1 ADD KEY i1 USING BTREE (c1);
2809 SHOW CREATE TABLE t1;
2811 t1 CREATE TABLE `t1` (
2812 `c1` year(4) NOT NULL,
2813 KEY `i1` (`c1`) USING BTREE
2814 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2818 CREATE TABLE t1(c1 BIT NOT NULL);
2822 SHOW CREATE TABLE t1;
2824 t1 CREATE TABLE `t1` (
2825 `c1` bit(1) NOT NULL
2826 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2827 ALTER TABLE t1 ADD KEY i1 USING HASH (c1);
2831 SHOW CREATE TABLE t1;
2833 t1 CREATE TABLE `t1` (
2834 `c1` bit(1) NOT NULL,
2835 KEY `i1` (`c1`) USING HASH
2836 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2840 CREATE TABLE t1(c1 TINYINT NOT NULL);
2844 SHOW CREATE TABLE t1;
2846 t1 CREATE TABLE `t1` (
2847 `c1` tinyint(4) NOT NULL
2848 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2849 ALTER TABLE t1 ADD KEY i1 USING HASH (c1);
2853 SHOW CREATE TABLE t1;
2855 t1 CREATE TABLE `t1` (
2856 `c1` tinyint(4) NOT NULL,
2857 KEY `i1` (`c1`) USING HASH
2858 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2862 CREATE TABLE t1(c1 SMALLINT NOT NULL);
2866 SHOW CREATE TABLE t1;
2868 t1 CREATE TABLE `t1` (
2869 `c1` smallint(6) NOT NULL
2870 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2871 ALTER TABLE t1 ADD KEY i1 USING HASH (c1);
2875 SHOW CREATE TABLE t1;
2877 t1 CREATE TABLE `t1` (
2878 `c1` smallint(6) NOT NULL,
2879 KEY `i1` (`c1`) USING HASH
2880 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2884 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
2888 SHOW CREATE TABLE t1;
2890 t1 CREATE TABLE `t1` (
2891 `c1` mediumint(9) NOT NULL
2892 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2893 ALTER TABLE t1 ADD KEY i1 USING HASH (c1);
2897 SHOW CREATE TABLE t1;
2899 t1 CREATE TABLE `t1` (
2900 `c1` mediumint(9) NOT NULL,
2901 KEY `i1` (`c1`) USING HASH
2902 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2906 CREATE TABLE t1(c1 INT NOT NULL);
2910 SHOW CREATE TABLE t1;
2912 t1 CREATE TABLE `t1` (
2913 `c1` int(11) NOT NULL
2914 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2915 ALTER TABLE t1 ADD KEY i1 USING HASH (c1);
2919 SHOW CREATE TABLE t1;
2921 t1 CREATE TABLE `t1` (
2922 `c1` int(11) NOT NULL,
2923 KEY `i1` (`c1`) USING HASH
2924 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2928 CREATE TABLE t1(c1 INTEGER NOT NULL);
2932 SHOW CREATE TABLE t1;
2934 t1 CREATE TABLE `t1` (
2935 `c1` int(11) NOT NULL
2936 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2937 ALTER TABLE t1 ADD KEY i1 USING HASH (c1);
2941 SHOW CREATE TABLE t1;
2943 t1 CREATE TABLE `t1` (
2944 `c1` int(11) NOT NULL,
2945 KEY `i1` (`c1`) USING HASH
2946 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2950 CREATE TABLE t1(c1 BIGINT NOT NULL);
2954 SHOW CREATE TABLE t1;
2956 t1 CREATE TABLE `t1` (
2957 `c1` bigint(20) NOT NULL
2958 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2959 ALTER TABLE t1 ADD KEY i1 USING HASH (c1);
2963 SHOW CREATE TABLE t1;
2965 t1 CREATE TABLE `t1` (
2966 `c1` bigint(20) NOT NULL,
2967 KEY `i1` (`c1`) USING HASH
2968 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2972 CREATE TABLE t1(c1 REAL NOT NULL);
2976 SHOW CREATE TABLE t1;
2978 t1 CREATE TABLE `t1` (
2979 `c1` double NOT NULL
2980 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2981 ALTER TABLE t1 ADD KEY i1 USING HASH (c1);
2985 SHOW CREATE TABLE t1;
2987 t1 CREATE TABLE `t1` (
2988 `c1` double NOT NULL,
2989 KEY `i1` (`c1`) USING HASH
2990 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
2994 CREATE TABLE t1(c1 DOUBLE NOT NULL);
2998 SHOW CREATE TABLE t1;
3000 t1 CREATE TABLE `t1` (
3001 `c1` double NOT NULL
3002 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3003 ALTER TABLE t1 ADD KEY i1 USING HASH (c1);
3007 SHOW CREATE TABLE t1;
3009 t1 CREATE TABLE `t1` (
3010 `c1` double NOT NULL,
3011 KEY `i1` (`c1`) USING HASH
3012 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3016 CREATE TABLE t1(c1 FLOAT NOT NULL);
3020 SHOW CREATE TABLE t1;
3022 t1 CREATE TABLE `t1` (
3024 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3025 ALTER TABLE t1 ADD KEY i1 USING HASH (c1);
3029 SHOW CREATE TABLE t1;
3031 t1 CREATE TABLE `t1` (
3032 `c1` float NOT NULL,
3033 KEY `i1` (`c1`) USING HASH
3034 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3038 CREATE TABLE t1(c1 DECIMAL NOT NULL);
3042 SHOW CREATE TABLE t1;
3044 t1 CREATE TABLE `t1` (
3045 `c1` decimal(10,0) NOT NULL
3046 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3047 ALTER TABLE t1 ADD KEY i1 USING HASH (c1);
3051 SHOW CREATE TABLE t1;
3053 t1 CREATE TABLE `t1` (
3054 `c1` decimal(10,0) NOT NULL,
3055 KEY `i1` (`c1`) USING HASH
3056 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3060 CREATE TABLE t1(c1 NUMERIC NOT NULL);
3064 SHOW CREATE TABLE t1;
3066 t1 CREATE TABLE `t1` (
3067 `c1` decimal(10,0) NOT NULL
3068 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3069 ALTER TABLE t1 ADD KEY i1 USING HASH (c1);
3073 SHOW CREATE TABLE t1;
3075 t1 CREATE TABLE `t1` (
3076 `c1` decimal(10,0) NOT NULL,
3077 KEY `i1` (`c1`) USING HASH
3078 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3082 CREATE TABLE t1(c1 DATE NOT NULL);
3086 SHOW CREATE TABLE t1;
3088 t1 CREATE TABLE `t1` (
3090 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3091 ALTER TABLE t1 ADD KEY i1 USING HASH (c1);
3095 SHOW CREATE TABLE t1;
3097 t1 CREATE TABLE `t1` (
3099 KEY `i1` (`c1`) USING HASH
3100 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3104 CREATE TABLE t1(c1 TIME NOT NULL);
3108 SHOW CREATE TABLE t1;
3110 t1 CREATE TABLE `t1` (
3112 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3113 ALTER TABLE t1 ADD KEY i1 USING HASH (c1);
3117 SHOW CREATE TABLE t1;
3119 t1 CREATE TABLE `t1` (
3121 KEY `i1` (`c1`) USING HASH
3122 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3126 CREATE TABLE t1(c1 TIMESTAMP NOT NULL);
3130 SHOW CREATE TABLE t1;
3132 t1 CREATE TABLE `t1` (
3133 `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
3134 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3135 ALTER TABLE t1 ADD KEY i1 USING HASH (c1);
3139 SHOW CREATE TABLE t1;
3141 t1 CREATE TABLE `t1` (
3142 `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
3143 KEY `i1` (`c1`) USING HASH
3144 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3148 CREATE TABLE t1(c1 YEAR NOT NULL);
3152 SHOW CREATE TABLE t1;
3154 t1 CREATE TABLE `t1` (
3155 `c1` year(4) NOT NULL
3156 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3157 ALTER TABLE t1 ADD KEY i1 USING HASH (c1);
3161 SHOW CREATE TABLE t1;
3163 t1 CREATE TABLE `t1` (
3164 `c1` year(4) NOT NULL,
3165 KEY `i1` (`c1`) USING HASH
3166 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3170 CREATE TABLE t1(c1 BIT NOT NULL);
3174 SHOW CREATE TABLE t1;
3176 t1 CREATE TABLE `t1` (
3177 `c1` bit(1) NOT NULL
3178 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3179 ALTER TABLE t1 ADD INDEX i1 (c1);
3183 SHOW CREATE TABLE t1;
3185 t1 CREATE TABLE `t1` (
3186 `c1` bit(1) NOT NULL,
3188 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3192 CREATE TABLE t1(c1 TINYINT NOT NULL);
3196 SHOW CREATE TABLE t1;
3198 t1 CREATE TABLE `t1` (
3199 `c1` tinyint(4) NOT NULL
3200 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3201 ALTER TABLE t1 ADD INDEX i1 (c1);
3205 SHOW CREATE TABLE t1;
3207 t1 CREATE TABLE `t1` (
3208 `c1` tinyint(4) NOT NULL,
3210 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3214 CREATE TABLE t1(c1 SMALLINT NOT NULL);
3218 SHOW CREATE TABLE t1;
3220 t1 CREATE TABLE `t1` (
3221 `c1` smallint(6) NOT NULL
3222 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3223 ALTER TABLE t1 ADD INDEX i1 (c1);
3227 SHOW CREATE TABLE t1;
3229 t1 CREATE TABLE `t1` (
3230 `c1` smallint(6) NOT NULL,
3232 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3236 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
3240 SHOW CREATE TABLE t1;
3242 t1 CREATE TABLE `t1` (
3243 `c1` mediumint(9) NOT NULL
3244 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3245 ALTER TABLE t1 ADD INDEX i1 (c1);
3249 SHOW CREATE TABLE t1;
3251 t1 CREATE TABLE `t1` (
3252 `c1` mediumint(9) NOT NULL,
3254 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3258 CREATE TABLE t1(c1 INT NOT NULL);
3262 SHOW CREATE TABLE t1;
3264 t1 CREATE TABLE `t1` (
3265 `c1` int(11) NOT NULL
3266 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3267 ALTER TABLE t1 ADD INDEX i1 (c1);
3271 SHOW CREATE TABLE t1;
3273 t1 CREATE TABLE `t1` (
3274 `c1` int(11) NOT NULL,
3276 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3280 CREATE TABLE t1(c1 INTEGER NOT NULL);
3284 SHOW CREATE TABLE t1;
3286 t1 CREATE TABLE `t1` (
3287 `c1` int(11) NOT NULL
3288 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3289 ALTER TABLE t1 ADD INDEX i1 (c1);
3293 SHOW CREATE TABLE t1;
3295 t1 CREATE TABLE `t1` (
3296 `c1` int(11) NOT NULL,
3298 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3302 CREATE TABLE t1(c1 BIGINT NOT NULL);
3306 SHOW CREATE TABLE t1;
3308 t1 CREATE TABLE `t1` (
3309 `c1` bigint(20) NOT NULL
3310 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3311 ALTER TABLE t1 ADD INDEX i1 (c1);
3315 SHOW CREATE TABLE t1;
3317 t1 CREATE TABLE `t1` (
3318 `c1` bigint(20) NOT NULL,
3320 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3324 CREATE TABLE t1(c1 REAL NOT NULL);
3328 SHOW CREATE TABLE t1;
3330 t1 CREATE TABLE `t1` (
3331 `c1` double NOT NULL
3332 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3333 ALTER TABLE t1 ADD INDEX i1 (c1);
3337 SHOW CREATE TABLE t1;
3339 t1 CREATE TABLE `t1` (
3340 `c1` double NOT NULL,
3342 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3346 CREATE TABLE t1(c1 DOUBLE NOT NULL);
3350 SHOW CREATE TABLE t1;
3352 t1 CREATE TABLE `t1` (
3353 `c1` double NOT NULL
3354 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3355 ALTER TABLE t1 ADD INDEX i1 (c1);
3359 SHOW CREATE TABLE t1;
3361 t1 CREATE TABLE `t1` (
3362 `c1` double NOT NULL,
3364 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3368 CREATE TABLE t1(c1 FLOAT NOT NULL);
3372 SHOW CREATE TABLE t1;
3374 t1 CREATE TABLE `t1` (
3376 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3377 ALTER TABLE t1 ADD INDEX i1 (c1);
3381 SHOW CREATE TABLE t1;
3383 t1 CREATE TABLE `t1` (
3384 `c1` float NOT NULL,
3386 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3390 CREATE TABLE t1(c1 DECIMAL NOT NULL);
3394 SHOW CREATE TABLE t1;
3396 t1 CREATE TABLE `t1` (
3397 `c1` decimal(10,0) NOT NULL
3398 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3399 ALTER TABLE t1 ADD INDEX i1 (c1);
3403 SHOW CREATE TABLE t1;
3405 t1 CREATE TABLE `t1` (
3406 `c1` decimal(10,0) NOT NULL,
3408 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3412 CREATE TABLE t1(c1 NUMERIC NOT NULL);
3416 SHOW CREATE TABLE t1;
3418 t1 CREATE TABLE `t1` (
3419 `c1` decimal(10,0) NOT NULL
3420 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3421 ALTER TABLE t1 ADD INDEX i1 (c1);
3425 SHOW CREATE TABLE t1;
3427 t1 CREATE TABLE `t1` (
3428 `c1` decimal(10,0) NOT NULL,
3430 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3434 CREATE TABLE t1(c1 DATE NOT NULL);
3438 SHOW CREATE TABLE t1;
3440 t1 CREATE TABLE `t1` (
3442 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3443 ALTER TABLE t1 ADD INDEX i1 (c1);
3447 SHOW CREATE TABLE t1;
3449 t1 CREATE TABLE `t1` (
3452 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3456 CREATE TABLE t1(c1 TIME NOT NULL);
3460 SHOW CREATE TABLE t1;
3462 t1 CREATE TABLE `t1` (
3464 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3465 ALTER TABLE t1 ADD INDEX i1 (c1);
3469 SHOW CREATE TABLE t1;
3471 t1 CREATE TABLE `t1` (
3474 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3478 CREATE TABLE t1(c1 TIMESTAMP NOT NULL);
3482 SHOW CREATE TABLE t1;
3484 t1 CREATE TABLE `t1` (
3485 `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
3486 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3487 ALTER TABLE t1 ADD INDEX i1 (c1);
3491 SHOW CREATE TABLE t1;
3493 t1 CREATE TABLE `t1` (
3494 `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
3496 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3500 CREATE TABLE t1(c1 YEAR NOT NULL);
3504 SHOW CREATE TABLE t1;
3506 t1 CREATE TABLE `t1` (
3507 `c1` year(4) NOT NULL
3508 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3509 ALTER TABLE t1 ADD INDEX i1 (c1);
3513 SHOW CREATE TABLE t1;
3515 t1 CREATE TABLE `t1` (
3516 `c1` year(4) NOT NULL,
3518 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3522 CREATE TABLE t1(c1 BIT NOT NULL);
3526 SHOW CREATE TABLE t1;
3528 t1 CREATE TABLE `t1` (
3529 `c1` bit(1) NOT NULL
3530 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3531 ALTER TABLE t1 ADD INDEX i1 USING BTREE (c1);
3535 SHOW CREATE TABLE t1;
3537 t1 CREATE TABLE `t1` (
3538 `c1` bit(1) NOT NULL,
3539 KEY `i1` (`c1`) USING BTREE
3540 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3544 CREATE TABLE t1(c1 TINYINT NOT NULL);
3548 SHOW CREATE TABLE t1;
3550 t1 CREATE TABLE `t1` (
3551 `c1` tinyint(4) NOT NULL
3552 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3553 ALTER TABLE t1 ADD INDEX i1 USING BTREE (c1);
3557 SHOW CREATE TABLE t1;
3559 t1 CREATE TABLE `t1` (
3560 `c1` tinyint(4) NOT NULL,
3561 KEY `i1` (`c1`) USING BTREE
3562 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3566 CREATE TABLE t1(c1 SMALLINT NOT NULL);
3570 SHOW CREATE TABLE t1;
3572 t1 CREATE TABLE `t1` (
3573 `c1` smallint(6) NOT NULL
3574 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3575 ALTER TABLE t1 ADD INDEX i1 USING BTREE (c1);
3579 SHOW CREATE TABLE t1;
3581 t1 CREATE TABLE `t1` (
3582 `c1` smallint(6) NOT NULL,
3583 KEY `i1` (`c1`) USING BTREE
3584 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3588 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
3592 SHOW CREATE TABLE t1;
3594 t1 CREATE TABLE `t1` (
3595 `c1` mediumint(9) NOT NULL
3596 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3597 ALTER TABLE t1 ADD INDEX i1 USING BTREE (c1);
3601 SHOW CREATE TABLE t1;
3603 t1 CREATE TABLE `t1` (
3604 `c1` mediumint(9) NOT NULL,
3605 KEY `i1` (`c1`) USING BTREE
3606 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3610 CREATE TABLE t1(c1 INT NOT NULL);
3614 SHOW CREATE TABLE t1;
3616 t1 CREATE TABLE `t1` (
3617 `c1` int(11) NOT NULL
3618 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3619 ALTER TABLE t1 ADD INDEX i1 USING BTREE (c1);
3623 SHOW CREATE TABLE t1;
3625 t1 CREATE TABLE `t1` (
3626 `c1` int(11) NOT NULL,
3627 KEY `i1` (`c1`) USING BTREE
3628 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3632 CREATE TABLE t1(c1 INTEGER NOT NULL);
3636 SHOW CREATE TABLE t1;
3638 t1 CREATE TABLE `t1` (
3639 `c1` int(11) NOT NULL
3640 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3641 ALTER TABLE t1 ADD INDEX i1 USING BTREE (c1);
3645 SHOW CREATE TABLE t1;
3647 t1 CREATE TABLE `t1` (
3648 `c1` int(11) NOT NULL,
3649 KEY `i1` (`c1`) USING BTREE
3650 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3654 CREATE TABLE t1(c1 BIGINT NOT NULL);
3658 SHOW CREATE TABLE t1;
3660 t1 CREATE TABLE `t1` (
3661 `c1` bigint(20) NOT NULL
3662 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3663 ALTER TABLE t1 ADD INDEX i1 USING BTREE (c1);
3667 SHOW CREATE TABLE t1;
3669 t1 CREATE TABLE `t1` (
3670 `c1` bigint(20) NOT NULL,
3671 KEY `i1` (`c1`) USING BTREE
3672 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3676 CREATE TABLE t1(c1 REAL NOT NULL);
3680 SHOW CREATE TABLE t1;
3682 t1 CREATE TABLE `t1` (
3683 `c1` double NOT NULL
3684 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3685 ALTER TABLE t1 ADD INDEX i1 USING BTREE (c1);
3689 SHOW CREATE TABLE t1;
3691 t1 CREATE TABLE `t1` (
3692 `c1` double NOT NULL,
3693 KEY `i1` (`c1`) USING BTREE
3694 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3698 CREATE TABLE t1(c1 DOUBLE NOT NULL);
3702 SHOW CREATE TABLE t1;
3704 t1 CREATE TABLE `t1` (
3705 `c1` double NOT NULL
3706 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3707 ALTER TABLE t1 ADD INDEX i1 USING BTREE (c1);
3711 SHOW CREATE TABLE t1;
3713 t1 CREATE TABLE `t1` (
3714 `c1` double NOT NULL,
3715 KEY `i1` (`c1`) USING BTREE
3716 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3720 CREATE TABLE t1(c1 FLOAT NOT NULL);
3724 SHOW CREATE TABLE t1;
3726 t1 CREATE TABLE `t1` (
3728 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3729 ALTER TABLE t1 ADD INDEX i1 USING BTREE (c1);
3733 SHOW CREATE TABLE t1;
3735 t1 CREATE TABLE `t1` (
3736 `c1` float NOT NULL,
3737 KEY `i1` (`c1`) USING BTREE
3738 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3742 CREATE TABLE t1(c1 DECIMAL NOT NULL);
3746 SHOW CREATE TABLE t1;
3748 t1 CREATE TABLE `t1` (
3749 `c1` decimal(10,0) NOT NULL
3750 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3751 ALTER TABLE t1 ADD INDEX i1 USING BTREE (c1);
3755 SHOW CREATE TABLE t1;
3757 t1 CREATE TABLE `t1` (
3758 `c1` decimal(10,0) NOT NULL,
3759 KEY `i1` (`c1`) USING BTREE
3760 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3764 CREATE TABLE t1(c1 NUMERIC NOT NULL);
3768 SHOW CREATE TABLE t1;
3770 t1 CREATE TABLE `t1` (
3771 `c1` decimal(10,0) NOT NULL
3772 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3773 ALTER TABLE t1 ADD INDEX i1 USING BTREE (c1);
3777 SHOW CREATE TABLE t1;
3779 t1 CREATE TABLE `t1` (
3780 `c1` decimal(10,0) NOT NULL,
3781 KEY `i1` (`c1`) USING BTREE
3782 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3786 CREATE TABLE t1(c1 DATE NOT NULL);
3790 SHOW CREATE TABLE t1;
3792 t1 CREATE TABLE `t1` (
3794 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3795 ALTER TABLE t1 ADD INDEX i1 USING BTREE (c1);
3799 SHOW CREATE TABLE t1;
3801 t1 CREATE TABLE `t1` (
3803 KEY `i1` (`c1`) USING BTREE
3804 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3808 CREATE TABLE t1(c1 TIME NOT NULL);
3812 SHOW CREATE TABLE t1;
3814 t1 CREATE TABLE `t1` (
3816 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3817 ALTER TABLE t1 ADD INDEX i1 USING BTREE (c1);
3821 SHOW CREATE TABLE t1;
3823 t1 CREATE TABLE `t1` (
3825 KEY `i1` (`c1`) USING BTREE
3826 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3830 CREATE TABLE t1(c1 TIMESTAMP NOT NULL);
3834 SHOW CREATE TABLE t1;
3836 t1 CREATE TABLE `t1` (
3837 `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
3838 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3839 ALTER TABLE t1 ADD INDEX i1 USING BTREE (c1);
3843 SHOW CREATE TABLE t1;
3845 t1 CREATE TABLE `t1` (
3846 `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
3847 KEY `i1` (`c1`) USING BTREE
3848 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3852 CREATE TABLE t1(c1 YEAR NOT NULL);
3856 SHOW CREATE TABLE t1;
3858 t1 CREATE TABLE `t1` (
3859 `c1` year(4) NOT NULL
3860 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3861 ALTER TABLE t1 ADD INDEX i1 USING BTREE (c1);
3865 SHOW CREATE TABLE t1;
3867 t1 CREATE TABLE `t1` (
3868 `c1` year(4) NOT NULL,
3869 KEY `i1` (`c1`) USING BTREE
3870 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3874 CREATE TABLE t1(c1 BIT NOT NULL);
3878 SHOW CREATE TABLE t1;
3880 t1 CREATE TABLE `t1` (
3881 `c1` bit(1) NOT NULL
3882 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3883 ALTER TABLE t1 ADD INDEX i1 USING HASH (c1);
3887 SHOW CREATE TABLE t1;
3889 t1 CREATE TABLE `t1` (
3890 `c1` bit(1) NOT NULL,
3891 KEY `i1` (`c1`) USING HASH
3892 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3896 CREATE TABLE t1(c1 TINYINT NOT NULL);
3900 SHOW CREATE TABLE t1;
3902 t1 CREATE TABLE `t1` (
3903 `c1` tinyint(4) NOT NULL
3904 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3905 ALTER TABLE t1 ADD INDEX i1 USING HASH (c1);
3909 SHOW CREATE TABLE t1;
3911 t1 CREATE TABLE `t1` (
3912 `c1` tinyint(4) NOT NULL,
3913 KEY `i1` (`c1`) USING HASH
3914 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3918 CREATE TABLE t1(c1 SMALLINT NOT NULL);
3922 SHOW CREATE TABLE t1;
3924 t1 CREATE TABLE `t1` (
3925 `c1` smallint(6) NOT NULL
3926 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3927 ALTER TABLE t1 ADD INDEX i1 USING HASH (c1);
3931 SHOW CREATE TABLE t1;
3933 t1 CREATE TABLE `t1` (
3934 `c1` smallint(6) NOT NULL,
3935 KEY `i1` (`c1`) USING HASH
3936 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3940 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
3944 SHOW CREATE TABLE t1;
3946 t1 CREATE TABLE `t1` (
3947 `c1` mediumint(9) NOT NULL
3948 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3949 ALTER TABLE t1 ADD INDEX i1 USING HASH (c1);
3953 SHOW CREATE TABLE t1;
3955 t1 CREATE TABLE `t1` (
3956 `c1` mediumint(9) NOT NULL,
3957 KEY `i1` (`c1`) USING HASH
3958 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3962 CREATE TABLE t1(c1 INT NOT NULL);
3966 SHOW CREATE TABLE t1;
3968 t1 CREATE TABLE `t1` (
3969 `c1` int(11) NOT NULL
3970 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3971 ALTER TABLE t1 ADD INDEX i1 USING HASH (c1);
3975 SHOW CREATE TABLE t1;
3977 t1 CREATE TABLE `t1` (
3978 `c1` int(11) NOT NULL,
3979 KEY `i1` (`c1`) USING HASH
3980 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3984 CREATE TABLE t1(c1 INTEGER NOT NULL);
3988 SHOW CREATE TABLE t1;
3990 t1 CREATE TABLE `t1` (
3991 `c1` int(11) NOT NULL
3992 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
3993 ALTER TABLE t1 ADD INDEX i1 USING HASH (c1);
3997 SHOW CREATE TABLE t1;
3999 t1 CREATE TABLE `t1` (
4000 `c1` int(11) NOT NULL,
4001 KEY `i1` (`c1`) USING HASH
4002 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
4006 CREATE TABLE t1(c1 BIGINT NOT NULL);
4010 SHOW CREATE TABLE t1;
4012 t1 CREATE TABLE `t1` (
4013 `c1` bigint(20) NOT NULL
4014 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
4015 ALTER TABLE t1 ADD INDEX i1 USING HASH (c1);
4019 SHOW CREATE TABLE t1;
4021 t1 CREATE TABLE `t1` (
4022 `c1` bigint(20) NOT NULL,
4023 KEY `i1` (`c1`) USING HASH
4024 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
4028 CREATE TABLE t1(c1 REAL NOT NULL);
4032 SHOW CREATE TABLE t1;
4034 t1 CREATE TABLE `t1` (
4035 `c1` double NOT NULL
4036 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
4037 ALTER TABLE t1 ADD INDEX i1 USING HASH (c1);
4041 SHOW CREATE TABLE t1;
4043 t1 CREATE TABLE `t1` (
4044 `c1` double NOT NULL,
4045 KEY `i1` (`c1`) USING HASH
4046 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
4050 CREATE TABLE t1(c1 DOUBLE NOT NULL);
4054 SHOW CREATE TABLE t1;
4056 t1 CREATE TABLE `t1` (
4057 `c1` double NOT NULL
4058 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
4059 ALTER TABLE t1 ADD INDEX i1 USING HASH (c1);
4063 SHOW CREATE TABLE t1;
4065 t1 CREATE TABLE `t1` (
4066 `c1` double NOT NULL,
4067 KEY `i1` (`c1`) USING HASH
4068 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
4072 CREATE TABLE t1(c1 FLOAT NOT NULL);
4076 SHOW CREATE TABLE t1;
4078 t1 CREATE TABLE `t1` (
4080 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
4081 ALTER TABLE t1 ADD INDEX i1 USING HASH (c1);
4085 SHOW CREATE TABLE t1;
4087 t1 CREATE TABLE `t1` (
4088 `c1` float NOT NULL,
4089 KEY `i1` (`c1`) USING HASH
4090 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
4094 CREATE TABLE t1(c1 DECIMAL NOT NULL);
4098 SHOW CREATE TABLE t1;
4100 t1 CREATE TABLE `t1` (
4101 `c1` decimal(10,0) NOT NULL
4102 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
4103 ALTER TABLE t1 ADD INDEX i1 USING HASH (c1);
4107 SHOW CREATE TABLE t1;
4109 t1 CREATE TABLE `t1` (
4110 `c1` decimal(10,0) NOT NULL,
4111 KEY `i1` (`c1`) USING HASH
4112 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
4116 CREATE TABLE t1(c1 NUMERIC NOT NULL);
4120 SHOW CREATE TABLE t1;
4122 t1 CREATE TABLE `t1` (
4123 `c1` decimal(10,0) NOT NULL
4124 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
4125 ALTER TABLE t1 ADD INDEX i1 USING HASH (c1);
4129 SHOW CREATE TABLE t1;
4131 t1 CREATE TABLE `t1` (
4132 `c1` decimal(10,0) NOT NULL,
4133 KEY `i1` (`c1`) USING HASH
4134 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
4138 CREATE TABLE t1(c1 DATE NOT NULL);
4142 SHOW CREATE TABLE t1;
4144 t1 CREATE TABLE `t1` (
4146 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
4147 ALTER TABLE t1 ADD INDEX i1 USING HASH (c1);
4151 SHOW CREATE TABLE t1;
4153 t1 CREATE TABLE `t1` (
4155 KEY `i1` (`c1`) USING HASH
4156 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
4160 CREATE TABLE t1(c1 TIME NOT NULL);
4164 SHOW CREATE TABLE t1;
4166 t1 CREATE TABLE `t1` (
4168 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
4169 ALTER TABLE t1 ADD INDEX i1 USING HASH (c1);
4173 SHOW CREATE TABLE t1;
4175 t1 CREATE TABLE `t1` (
4177 KEY `i1` (`c1`) USING HASH
4178 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
4182 CREATE TABLE t1(c1 TIMESTAMP NOT NULL);
4186 SHOW CREATE TABLE t1;
4188 t1 CREATE TABLE `t1` (
4189 `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
4190 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
4191 ALTER TABLE t1 ADD INDEX i1 USING HASH (c1);
4195 SHOW CREATE TABLE t1;
4197 t1 CREATE TABLE `t1` (
4198 `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
4199 KEY `i1` (`c1`) USING HASH
4200 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
4204 CREATE TABLE t1(c1 YEAR NOT NULL);
4208 SHOW CREATE TABLE t1;
4210 t1 CREATE TABLE `t1` (
4211 `c1` year(4) NOT NULL
4212 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
4213 ALTER TABLE t1 ADD INDEX i1 USING HASH (c1);
4217 SHOW CREATE TABLE t1;
4219 t1 CREATE TABLE `t1` (
4220 `c1` year(4) NOT NULL,
4221 KEY `i1` (`c1`) USING HASH
4222 ) ENGINE=ENGINE DEFAULT CHARSET=latin1