CREATE [UNIQUE|FULLTEXT|SPATIAL] INDEX index_name
[index_type]
ON tbl_name (index_col_name,...)index_col_name:
col_name [(length)] [ASC | DESC]index_type:
USING {BTREE | HASH}PS:
set your index on those condition field. after setting up the index, you would feel a bit of slowly when inserting or deleting, because the index is working. But you would see the searching is much fast.
[index_type]
ON tbl_name (index_col_name,...)index_col_name:
col_name [(length)] [ASC | DESC]index_type:
USING {BTREE | HASH}PS:
set your index on those condition field. after setting up the index, you would feel a bit of slowly when inserting or deleting, because the index is working. But you would see the searching is much fast.
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货