1DROP TABLE IF EXISTS t1; 2CREATE TABLE t1(c1 INTEGER NOT NULL); 3CREATE INDEX i1 USING BTREE ON t1(c1 ASC); 4SHOW CREATE TABLE t1; 5Table Create Table 6t1 CREATE TABLE `t1` ( 7 `c1` int NOT NULL, 8 KEY `i1` (`c1`) USING BTREE 9) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 10DROP INDEX i1 ON t1; 11DROP TABLE t1; 12SHOW TABLES; 13Tables_in_test 14CREATE TABLE t1(c1 INTEGER NOT NULL); 15CREATE INDEX i1 USING BTREE ON t1(c1); 16SHOW CREATE TABLE t1; 17Table Create Table 18t1 CREATE TABLE `t1` ( 19 `c1` int NOT NULL, 20 KEY `i1` (`c1`) USING BTREE 21) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 22DROP TABLE t1; 23SHOW TABLES; 24Tables_in_test 25CREATE TABLE t1(c1 INTEGER NOT NULL); 26CREATE UNIQUE INDEX i1 USING BTREE ON t1(c1 ASC); 27SHOW CREATE TABLE t1; 28Table Create Table 29t1 CREATE TABLE `t1` ( 30 `c1` int NOT NULL, 31 UNIQUE KEY `i1` (`c1`) USING BTREE 32) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 33DROP INDEX i1 ON t1; 34DROP TABLE t1; 35SHOW TABLES; 36Tables_in_test 37CREATE TABLE t1(c1 INTEGER NOT NULL); 38CREATE UNIQUE INDEX i1 USING BTREE ON t1(c1); 39SHOW CREATE TABLE t1; 40Table Create Table 41t1 CREATE TABLE `t1` ( 42 `c1` int NOT NULL, 43 UNIQUE KEY `i1` (`c1`) USING BTREE 44) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 45DROP INDEX i1 ON t1; 46DROP TABLE t1; 47SHOW TABLES; 48Tables_in_test 49CREATE TABLE t1(c1 INTEGER NOT NULL); 50CREATE INDEX i1 USING HASH ON t1(c1); 51Warnings: 52Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead. 53SHOW CREATE TABLE t1; 54Table Create Table 55t1 CREATE TABLE `t1` ( 56 `c1` int NOT NULL, 57 KEY `i1` (`c1`) 58) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 59DROP INDEX i1 ON t1; 60DROP TABLE t1; 61SHOW TABLES; 62Tables_in_test 63CREATE TABLE t1(c1 INTEGER NOT NULL); 64CREATE INDEX i1 USING HASH ON t1(c1); 65Warnings: 66Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead. 67SHOW CREATE TABLE t1; 68Table Create Table 69t1 CREATE TABLE `t1` ( 70 `c1` int NOT NULL, 71 KEY `i1` (`c1`) 72) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 73DROP INDEX i1 ON t1; 74DROP TABLE t1; 75SHOW TABLES; 76Tables_in_test 77CREATE TABLE t1(c1 INTEGER NOT NULL); 78CREATE UNIQUE INDEX i1 USING HASH ON t1(c1); 79Warnings: 80Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead. 81SHOW CREATE TABLE t1; 82Table Create Table 83t1 CREATE TABLE `t1` ( 84 `c1` int NOT NULL, 85 UNIQUE KEY `i1` (`c1`) 86) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 87DROP INDEX i1 ON t1; 88DROP TABLE t1; 89SHOW TABLES; 90Tables_in_test 91CREATE TABLE t1(c1 INTEGER NOT NULL); 92CREATE UNIQUE INDEX i1 USING HASH ON t1(c1); 93Warnings: 94Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead. 95SHOW CREATE TABLE t1; 96Table Create Table 97t1 CREATE TABLE `t1` ( 98 `c1` int NOT NULL, 99 UNIQUE KEY `i1` (`c1`) 100) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 101DROP INDEX i1 ON t1; 102DROP TABLE t1; 103SHOW TABLES; 104Tables_in_test 105