CREATE FULLTEXT INDEX idx_fulltext ON my_table (column3);     CREATE TABLE hash_index_table ( column1 INT, column2 CHAR(10), INDEX USING HASH (column1) ) ENGINE=MEMORY;     CREATE TABLE my_table ( id INT NOT NULL, column1 VARCHAR(100), PRIMARY KEY (id) );     CREATE TABLE spatial_table ( id INT NOT NULL AUTO_INCREMENT, geom GEOMETRY NOT NULL, SPATIAL INDEX(geom) );