Mysqli 简明教程

MySQLi - Drop Database

Drop a Database using mysqladmin

您将需要特殊权限来创建或删除 MySQL 数据库。因此，假设您可以访问 root 用户，那么可以使用 mysql mysqladmin 二进制文件创建任何数据库。

You would need special privileges to create or to delete a MySQL database. So, assuming you have access to the root user, you can create any database using the mysql mysqladmin binary.

删除任何数据库时要小心，因为这会让你失去数据库中所有可用数据。

Be careful while deleting any database because you will lose your all the data available in your database.

以下是一个示例，用于删除在上一个章节中创建的数据库 (TUTORIALS) −

Here is an example to delete a database(TUTORIALS) created in the previous chapter −

[root@host]# mysqladmin -u root -p drop TUTORIALS
Enter password:******

这会给你一个警告，并会确认你是否真的想删除此数据库。

This will give you a warning and it will confirm if you really want to delete this database or not.

Dropping the database is potentially a very bad thing to do.
Any data stored in the database will be destroyed.

Do you really want to drop the 'TUTORIALS' database [y/N] y
Database "TUTORIALS" dropped

Drop Database using PHP Script

PHP 使用 mysqli query() 或 mysql_query() 函数来删除 MySQL 数据库。这个函数接收两个参数，并在成功时返回 TRUE，并在失败时返回 FALSE。

PHP uses mysqli query() or mysql_query() function to drop a MySQL database. This function takes two parameters and returns TRUE on success or FALSE on failure.

Syntax

$mysqli→query($sql,$resultmode)

Sr.No.

Parameter & Description

1

$sql Required - SQL query to drop a MySQL database.

2

$resultmode Optional - Either the constant MYSQLI_USE_RESULT or MYSQLI_STORE_RESULT depending on the desired behavior. By default, MYSQLI_STORE_RESULT is used.

Example

尝试以下示例来删除数据库−

Try the following example to drop a database −

将以下示例复制粘贴为 mysql_example.php：

Copy and paste the following example as mysql_example.php −

<html>
   <head><title>Dropping MySQL Database</title></head>
   <body>
      <?php
         $dbhost = 'localhost';
         $dbuser = 'root';
         $dbpass = 'root@123';
         $mysqli = new mysqli($dbhost, $dbuser, $dbpass);

         if($mysqli->connect_errno ) {
            printf("Connect failed: %s<br />", $mysqli->connect_error);
            exit();
         }
         printf('Connected successfully.<br />');

         if ($mysqli->query("Drop DATABASE TUTORIALS")) {
            printf("Database TUTORIALS dropped successfully.<br />");
         }
         if ($mysqli->errno) {
            printf("Could not drop database: %s<br />", $mysqli->error);
         }
         $mysqli->close();
      ?>
   </body>
</html>

Output

访问部署在 Apache Web 服务器上的 mysql_example.php, 并验证输出。

Access the mysql_example.php deployed on apache web server and verify the output.

Connected successfully.
Database TUTORIALS dropped successfully.