一篇带给你MySQL高性能索引
复制CREATETABLE `test_hash` ( `full_name` varchar(255) DEFAULTNULL,篇带 `short_name` varchar(32) DEFAULTNULL, `age` int(11) DEFAULTNULL, KEY `idx` (`full_name`) USING HASH ) ENGINE=MEMORY DEFAULT CHARSET=utf8; 1.2.3.4.5.6.
复制CREATETABLE `test_hash` ( `full_name` varchar(255) DEFAULTNULL,篇带 `short_name` varchar(32) DEFAULTNULL, `age` int(11) DEFAULTNULL, KEY `idx` (`full_name`) USING HASH ) ENGINE=MEMORY DEFAULT CHARSET=utf8; 1.2.3.4.5.6.