CREATE TABLE `example` (

  `example_id` int(11) NOT NULL,

  `index_btree` int(11) NOT NULL,

  `index_hash` int(11) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

ALTER TABLE `example`

  ADD PRIMARY KEY (`example_id`),

  ADD KEY `example_hash` (`index_hash`) USING HASH,

  ADD KEY `example_btree` (`index_btree`) USING BTREE;

ALTER TABLE `example`

  MODIFY `example_id` int(11) NOT NULL AUTO_INCREMENT;

SHOW INDEX FROM example;