mysql_前缀索引

添加mysql前缀索引

ALTER TABLE table_name ADD KEY(column_name(prefix_length));