Code to batch delete data tables with the same prefix in Mysql in PHP_PHP Tutorial

Method 1:

Copy code The code is as follows:

mysql_connect('','', '');
mysql_select_db('');
$rs=mysql_query('show tables');
while($arr=mysql_fetch_array($rs)){
$TF=strpos( $arr[0],'class_');
if($TF===0){
$FT=mysql_query("drop table $arr[0]");
if($FT ){
echo "$arr[0] deleted successfully!
";
}
}
}
?>

Method 2:
Today I reinstalled my website and spent an afternoon working on it, and finally found a method that can be used to delete database tables in batches. . .
This is a demonstration using xx_ as the prefix. You can change it to the table prefix you want to delete

Copy the code The code is as follows:

function deldata($dbname,$tableflag){
$db_host = 'localhost';
$db_port = '3306';
$db_user = 'user ';
$db_pass = 'password';
$connect =mysql_connect($db_host,$db_user,$db_pass);
mysql_select_db($dbname);
$result = mysql_query("show table status from $dbname",$connect);
$data=mysql_fetch_array($result);
while($data=mysql_fetch_array($result)) {
$table=mysubstr($data[Name] ,"_");
if($table==$tableflag){
//For testing purpose
/*echo $data[Name];
echo "
";
echo $table;
echo "
";*/
mysql_query("drop table $data[Name]");
}
}
return true;
}
/*Intercept all characters before a specific character function
*$str is the string to be intercepted
*$flag specific characters such as "_"
*/
function mysubstr ($str,$flag){
$pos=strpos($str,$flag);
return substr($str,0,$pos);
}
?>

The changes are:
1. At the beginning

function deldata($dbname,$tableflag){
$db_host = 'localhost ';
$db_port = '3306';
$db_user = 'user';
$db_pass = 'password';
Change to your own database address, account number and password
2. Change the

at the end to your own database name and the table prefix you want to delete
. You can copy the above code and save it as .php, and then upload it to the space directory to open it.

http://www.bkjia.com/PHPjc/323724.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/323724.htmlTechArticleMethod 1: Copy the code as follows: ?php mysql_connect('','',''); mysql_select_db( ''); $rs=mysql_query('show tables'); while($arr=mysql_fetch_array($rs)){ $TF=strpos($arr[0],'cl...