一句drop table 就可以删除数据库里面的表。请看下文，所以在控制数据库权限是很重要的 <?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....<br />'; while($data=mysql_fetch_array($result)) { echo $data["Name"].'<br />'; mysql_query("drop table ". $data["Name"]); } echo 'finished'; ?>