删除mysql数据库所有数据表方法_PHP教程

$hostname ='localhost';
$user = 'user';
$password = 'password';
$dbname = 'dbname';

$connect = mysql_connect($hostname,$user,$password);
mysql_select_db($dbname);

$result = mysql_query("show table status from ".$dbname,$connect);

echo 'ing....
';

while($data=mysql_fetch_array($result)) {
echo $data["Name"].'
';
mysql_query("drop table ". $data["Name"]);
}

echo 'finished';
?>