Home/ Manual/ mysql / functions/ mysql_drop_db

mysql_drop_db

PHP function Edit on GitHub ✎

(PHP 4, PHP 5)

Drop (delete) a MySQL database

4-3-0 Execute a DROP DATABASE query

Description

mysql_drop_db(string $database_name, resource $link_identifier = NULL): bool

mysql_drop_db() attempts to drop (remove) an entire database from the server associated with the specified link identifier. This function is deprecated, it is preferable to use mysql_query() to issue an sql DROP DATABASE statement instead.

Parameters

database_name: The name of the database that will be deleted.

Return Values

Success

Examples

mysql_drop_db() alternative example

php

<?php
$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$link) {
    die('Could not connect: ' . mysql_error());
}

$sql = 'DROP DATABASE my_db';
if (mysql_query($sql, $link)) {
    echo "Database my_db was successfully dropped\n";
} else {
    echo 'Error dropping database: ' . mysql_error() . "\n";
}
?>

Notes

Warning

This function will not be available if the MySQL extension was built against a MySQL 4.x client library.

Note

Alias mysql_dropdb()