批量删除MYSQL里前缀相同的表
mysql_connect('localhost','username','password');
mysql_select_db('dbname');
$rs=mysql_query('show tables');
while($arr=mysql_fetch_array($rs))
{
$TF=strpos($arr[0],'bf_');
if($TF===0)
{
$FT=mysql_query("drop table $arr[0]");
if($FT)
{
echo "$arr[0] 删除成功!
“;
}
}
}
?>