";
}
}
$result = mysql_db_query($db, "SHOW KEYS FROM $table") or mysql_die();
$primary = "";
while ($row = mysql_fetch_array($result))
if ($row["Key_name"] == "PRIMARY")
$primary .= "$row[Column_name], ";
$result = mysql_db_query($db, "SHOW FIELDS FROM $table");
if (!$result)
{
mysql_die();
}
else
{
?>
0)
{
?>
>
|
|
|
|
";
if ($row["Key_name"] == "PRIMARY")
{
$sql_query = urlencode("ALTER TABLE ".$table." DROP PRIMARY KEY");
$zero_rows = urlencode($strPrimaryKey." ".$strHasBeenDropped);
}
else
{
$sql_query = urlencode("ALTER TABLE ".$table." DROP INDEX ".$row["Key_name"]);
$zero_rows = urlencode($strIndex." ".$row["Key_name"]." ".$strHasBeenDropped);
}
/* someone tell me why I must add those 3 arguments: - Marc */
// printf("%s | %s | %s | %s | ",$row["Key_name"],($row["Non_unique"]=="0")?$strYes:$strNo,$row["Column_name"],$strDrop);
?>
|
|
|
$strDrop";?> |
";
}
print "
\n";
print show_docu("manual_Performance.html#MySQL_indexes");
}
}
?>