如何在不删除数据库的情况下在 phpMyAdmin 中删除数据库中所有表的内容? [英] How can I delete the contents of all tables in my database in phpMyAdmin without dropping the database?

问题描述

如何在 phpMyAdmin 中清空我数据库中所有表的内容而不删除数据库中的任何表?

How can I empty the contents of all tables in my database in phpMyAdmin without dropping any of the tables in the database?

由于我在开发过程中每小时执行几次此操作，因此我不想每次都在所有 60 多个表上单独单击清空".

Since I do this several times an hour while in development, I'd rather not individually click "Empty" on all 60+ tables every time.

推荐答案

使用多个 DELETE 语句(每个表一个)创建一个 SQL 脚本并执行.

Create a SQL script with multiple DELETE statements (one for each table) and execute it.

进入 phpMyAdmin 并选择您想要的数据库.选择 SQL 选项卡并将 SQL 脚本粘贴到窗口中.点击开始.

Get into phpMyAdmin and select the database that you want. Select the SQL tab and paste the SQL script into the window. Hit Go.

也看这里:

从 MySQL 数据库中删除所有表而不删除

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