删除现有的MySQLi表非常容易，但删除任何现有表时需要非常小心，因为删除表后数据丢失将无法恢复.
以下是删除MySQLi表的通用SQL语法 :
DROP TABLE table_name ;
这只需要执行 DROP TABLE SQL命令在mysql>提示.
这是一个示例，删除 tutorials_inf :
root@host# mysql -u root -p Enter password:******* mysql> use TUTORIALS; Database changed mysql> DROP TABLE tutorials_inf Query OK, 0 rows affected (0.8 sec) mysql>
要删除任何数据库中的现有表，您需要使用PHP函数 mysqli_query()的.您将使用适当的SQL命令传递其第二个参数以删除表.
<html>
<head>
<title>Dropping MySQLi Tables</title>
</head>
<body>
<?php
$host = 'localhost:3306';
$user = 'root';
$pass = '';
$dbname = 'TUTORIALS';
$conn = mysqli_connect($host, $user, $pass,$dbname);
if(!$conn) {
die('Could not connect: '.mysqli_connect_error());
}
echo 'Connected successfully<br/>';
$sql = "DROP TABLE tutorials_inf";
if(mysqli_query($conn, $sql)) {
echo "Table is deleted successfully";
} else {
echo "Table is not deleted successfully\n";
}
mysqli_close($conn);
?>
</body>
</html>示例输出应该是这样的 :
Connected successfully Table is deleted successfully
