Mysqli 简明教程

MySQLi - Drop Table

删除现有的 MySQL 表格非常容易，但您在删除任何现有表格时需要非常小心，因为删除表格后丢失的数据将无法恢复。

It is very easy to drop an existing MySQL table, but you need to be very careful while deleting any existing table because the data lost will not be recovered after deleting a table.

Syntax

以下是删除 MySQL 表格的通用 SQL 语法 -

Here is a generic SQL syntax to drop a MySQL table −

DROP TABLE table_name ;

Dropping Tables from the Command Prompt

要从命令提示符删除表格，我们需要在 mysql> 提示符处执行 DROP TABLE SQL 命令。

To drop tables from the command prompt, we need to execute the DROP TABLE SQL command at the mysql> prompt.

Example

以下程序是一个删除 tutorials_tbl 的示例 -

The following program is an example which deletes the tutorials_tbl −

root@host# mysql -u root -p
Enter password:*******
mysql> use TUTORIALS;
Database changed
mysql> DROP TABLE tutorials_tbl
Query OK, 0 rows affected (0.8 sec)
mysql>

Dropping Tables Using PHP Script

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

PHP uses mysqli query() or mysql_query() function to drop a MySQL table. 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 table.

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 table −

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

Copy and paste the following example as mysql_example.php −

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

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

         if ($mysqli→query("Drop Table tutorials_tbl")) {
            printf("Table tutorials_tbl dropped successfully.<br />");
         }
         if ($mysqli→errno) {
            printf("Could not drop table: %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.
Table tutorials_tbl dropped successfully.