如何在不删除数据库本身的情况下删除数据库中的所有表? [英] How to drop all tables in database without dropping the database itself?

问题描述

我想从数据库中删除所有表，但不删除数据库本身.是否有可能 ?我只是在寻找比删除数据库并重新创建数据库更短的方法.谢谢！

I would like to delete all the tables from database, but not deleting the database itself. Is it possible ? I'm just looking for shorter way than removing the database and create it again. Thanks !

推荐答案

最短的是重新创建数据库.但是如果你不想...

The shortest is to re-create database. but if you don't want to...

这是针对MySQL/PHP的.未经测试，但类似的东西.

This is for MySQL/PHP. Not tested but something like that.

$mysqli = new mysqli("host", "my_user", "my_password", "database");
$mysqli->query('SET foreign_key_checks = 0');
if ($result = $mysqli->query("SHOW TABLES"))
{
    while($row = $result->fetch_array(MYSQLI_NUM))
    {
        $mysqli->query('DROP TABLE IF EXISTS '.$row[0]);
    }
}

$mysqli->query('SET foreign_key_checks = 1');
$mysqli->close();

这篇关于如何在不删除数据库本身的情况下删除数据库中的所有表?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！