How to bulk delete MySQL database data tables via phpMyAdmin

It is strongly recommended to back up the entire database before using this method. As for how to back up? You're not? Leave a message at the bottom of this article.

Specific methods: Copy the following PHP execution statement, save as sql.php file (note the configuration database name, password, data header), FTP upload to the site and directory, run.

<?php//Set the database connection information. Database server address, database user name, data password mysql_connect (' localhost ', ' root ', ' 123456 ');//Set the database name of the query, such as Cmsyou is currently set to Phpcmsmysql_select_ db (' Phpcms '), $rs =mysql_query (' Show Tables '), while ($arr =mysql_fetch_array ($rs)) {//sets the database table prefix to be deleted in bulk, such as: v9_    $TF = Strpos ($arr [0], ' v9_ ');    if ($TF ===0) {        $FT =mysql_query ("drop table $arr [0]");       if ($FT) {            echo "$arr [0] deleted successfully! <br> ";            }}        }? >

　　

How to bulk delete MySQL database data tables via phpMyAdmin