[Tips] the simplest way to clear a MYSQL database

Copy the following code and save it as ***. php, and it will be OK. lt ;? Php $ userquot; database username quot; $ passwordquot; Database Password quot; $

Copy the following code and save it as ***. php, and it will be OK. lt ;? Php $ user = quot; database username quot; // $ password = quot; Database password quot; // $

Copy the following code and save it as ***. php.

$ User = "database username ";//
$ Password = "Database password ";//
$ Db_name = "Database Name ";//

$ Link = mysql_connect ("localhost: 3306", $ user, $ password );
Mysql_select_db ("$ db_name", $ link );
Echo"

Clearing database ...";
$ Result = mysql_query ("SHOW tables", $ link );
While ($ currow = mysql_fetch_array ($ result )){
Mysql_query ("drop table if exists $ currow [0]");
Echo $ currow [0]."
";
}
Echo "successful

";

?>

// Upload the above code to any directory in the space and access it through the URL !!!

,