如何在不删除数据库的情况下在phpMyAdmin中删除数据库中所有表的内容?
问题描述：
如何在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.
也看这里: