 |
|
 PhpDig.net |
What is PhpDig?
PhpDig is a PHP MySQL based Web Spider & Search Engine. |
mysql_drop_db
Synopsis
bool mysql_drop_db(database_name[, connection]);
string database_name: Name
of the database to drop
mysql link connection
(optional): Connection handle returned by mysql_connect() or mysql_pconnect()
Description
mysql_drop_db() drops/deletes a MySQL database. Every table in the database is permanently removed. Databases can also be dropped by using a SQL query such as "DROP DATABASE ..."
Warning
Dropping a database is irreversible. The only way to recover the database is by restoring from backups!
See also
- To delete rows from a table:
-
Use mysql_query() with a DELETE query. See the MySQL documentation for more information.
Example
Example 797. Delete a MySQL database
<?php
// Included code that connects to a MySQL server and sets a default database
// See the MySQL Functions chapter introduction for the source code for the file
include ('mysql_connect.inc.php');
// Be very careful doing this! There is no way to undo a drop!!!
mysql_drop_db ($db)
or die ("Could not drop database '$db'.");
echo "Database '$db' was dropped.";
?>