mysql中创建索引

作者: zeroth123   发布时间: 2011-07-04

create index xxx on tb(col,col2)

作者: jinfengyiye   发布时间: 2011-07-04

mysql> if exists(select 1 from information_schema.statistics where table_schema=
'db' and table_name='tbName' and index_name='ix_name') drop index ix_name;

作者: jinfengyiye   发布时间: 2011-07-04