PHP code to delete all tables in MYSQL database_PHP tutorial

If you don’t want to delete the library, but just want to delete all the tables in the library, then use this script.

It’s very convenient.

The following is the quoted content:

以下为引用的内容：
.$hostname ='localhost';
$userid = 'user';
$password = 'password';
$dbname = 'dbname';
$connect = mysql_connect($hostname,$userid,$password);
mysql_select_db($dbname);
$result = mysql_query("show table status from $dbname",$connect);
while($data=mysql_fetch_array($result)) {
mysql_query("drop table $data[Name]");
}
?>

. $hostname = 'localhost';

$userid = 'user';

$password = 'password';

$dbname = 'dbname'; $connect = mysql_connect($hostname,$userid ,$password); mysql_select_db($dbname); $result = mysql_query("show table status from $dbname",$connect); while($data=mysql_fetch_array($result)) { mysql_query("drop table $data[Name]"); } ?>

http://www.bkjia.com/PHPjc/363978.htmlwww.bkjia.com

true

http: //www.bkjia.com/PHPjc/363978.htmlTechArticleIf you don’t want to delete the library, but just want to delete all the tables in the library, then use this script. It’s very convenient. . The following is the quoted content: .?php $hostname ='localhost'; $userid = 'user'; $passwo...