如何在不删除数据库的情况下在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屋！