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)
);
