如何创建索引和删除索引

类似

//Drop index
$sql = "ALTER TABLE `tbl_name` DROP INDEX `column_list`";
$result = $link->query($sql);
//add index
$sql = "ALTER TABLE `tbl_name` ADD INDEX index_name (column_list)";
$result = $link->query($sql);