创建及删除索引

更多内容

创建索引

ALTER TABLE tmp_contract ADD INDEX index_name (column_list)ALTER TABLE tmp_contract ADD UNIQUE index index_name(contract_id)ALTER TABLE tmp_contract ADD PRIMARY KEY(contract_id)ALTER TABLE tmp_contract ADD FULLTEXT ix_name_contract_id(contract_id)create index ix_name_contract_id ON tmp_contract(contract_id)create unique index ix_name_contract_id ON tmp_contract(contract_id)

删除索引

drop index ix_name_contract_id on tmp_contractalter table table_name DROP INDEX index_namealter table tmp_contract DROP PRIMARY KE