How to quickly delete all tables in MySQL without deleting the database

How to quickly delete all tables in MySQL without deleting the database

This article uses an example to describe how to quickly delete all tables in MySQL without deleting the database. Share with you for your reference, the details are as follows:

If you use phpmyadmin directly, it must be very simple. Check the data table -> click delete -> click OK, and the operation is complete!

Here we introduce the SQL command operation method for quickly deleting a data table.

Command to delete a table:

drop table table name;

If there are 200 tables and the execution is 200 times, I don't want to do it just thinking about it.

Here is a solution using the information_schema library:

Copy the code as follows:
SELECT CONCAT('drop table ',table_name,';') FROM information_schema.`TABLES` WHERE table_schema='database name';

Use this command to get statements such as drop table 表名; and then execute them in batches.

Look at the results of my execution. Remove the first line, and then delete all tables in the dede system.

If you are using the default table prefix, you can directly copy the following command and execute it.

CONCAT('drop table ',table_name,';')
DROP TABLE dede_addonarticle;
DROP TABLE dede_addonimages;
DROP TABLE dede_addoninfos;
DROP TABLE dede_addonshop;
DROP TABLE dede_addonsoft;
DROP TABLE dede_addonspec;
DROP TABLE dede_admin;
DROP TABLE dede_admintype;
DROP TABLE dede_advancedsearch;
DROP TABLE dede_arcatt;
DROP TABLE dede_arccache;
DROP TABLE dede_archives;
DROP TABLE dede_arcmulti;
DROP TABLE dede_arcrank;
DROP TABLE dede_arctiny;
DROP TABLE dede_arctype;
DROP TABLE dede_area;
DROP TABLE dede_channeltype;
DROP TABLE dede_co_htmls;
DROP TABLE dede_co_mediaurls;
DROP TABLE dede_co_note;
DROP TABLE dede_co_onepage;
DROP TABLE dede_co_urls;
DROP TABLE dede_diy_guestbook;
DROP TABLE dede_diyform1;
DROP TABLE dede_diyforms;
DROP TABLE dede_dl_log;
DROP TABLE dede_downloads;
DROP TABLE dede_erradd;
DROP TABLE dede_feedback;
DROP TABLE dede_flink;
DROP TABLE dede_flinktype;
DROP TABLE dede_freelist;
DROP TABLE dede_homepageset;
DROP TABLE dede_keywords;
DROP TABLE dede_log;
DROP TABLE dede_member;
DROP TABLE dede_member_company;
DROP TABLE dede_member_feed;
DROP TABLE dede_member_flink;
DROP TABLE dede_member_friends;
DROP TABLE dede_member_group;
DROP TABLE dede_member_guestbook;
DROP TABLE dede_member_model;
DROP TABLE dede_member_msg;
DROP TABLE dede_member_operation;
DROP TABLE dede_member_person;
DROP TABLE dede_member_pms;
DROP TABLE dede_member_snsmsg;
DROP TABLE dede_member_space;
DROP TABLE dede_member_stow;
DROP TABLE dede_member_stowtype;
DROP TABLE dede_member_tj;
DROP TABLE dede_member_type;
DROP TABLE dede_member_vhistory;
DROP TABLE dede_moneycard_record;
DROP TABLE dede_moneycard_type;
DROP TABLE dede_mtypes;
DROP TABLE dede_multiserv_config;
DROP TABLE dede_myad;
DROP TABLE dede_myadtype;
DROP TABLE dede_mytag;
DROP TABLE dede_payment;
DROP TABLE dede_plus;
DROP TABLE dede_purview;
DROP TABLE dede_pwd_tmp;
DROP TABLE dede_ratings;
DROP TABLE dede_scores;
DROP TABLE dede_search_cache;
DROP TABLE dede_search_keywords;
DROP TABLE dede_sgpage;
DROP TABLE dede_shops_delivery;
DROP TABLE dede_shops_orders;
DROP TABLE dede_shops_products;
DROP TABLE dede_shops_userinfo;
DROP TABLE dede_softconfig;
DROP TABLE dede_sphinx;
DROP TABLE dede_stepselect;
DROP TABLE dede_sys_enum;
DROP TABLE dede_sys_module;
DROP TABLE dede_sys_set;
DROP TABLE dede_sys_task;
DROP TABLE dede_sysconfig;
DROP TABLE dede_tagindex;
DROP TABLE dede_taglist;
DROP TABLE dede_uploads;
DROP TABLE dede_verifies;
DROP TABLE dede_vote;
DROP TABLE dede_vote_member;

Readers who are interested in more MySQL-related content can check out the following topics on this site: "MySQL query skills", "MySQL transaction operation skills", "MySQL stored procedure skills", "MySQL database lock related skills summary" and "MySQL common function summary"

I hope this article will be helpful to everyone's MySQL database design.

You may also be interested in:
  • Code for batch deleting data tables with the same prefix in Mysql in PHP
  • Detailed instructions and syntax for creating and deleting tables in MySQL
  • Getting Started with MySQL (IV) Inserting, Updating, and Deleting Data from a Table
  • How to delete a MySQL table
  • How to delete table data in MySQL
  • mysql drop database delete database command example explanation
  • Detailed explanation of how to find and delete duplicate data in MySQL and keep only one example
  • Comparison of MySQL Delete and Truncate statements
  • Summary of methods for deleting duplicate data in MySQL database
  • Mysql delete data and data table method example

<<:  How to solve the problem of command failure caused by overwriting the original PATH and prompting command not found

>>:  Specific use of node.js global variables

Recommend

Use VSCode's Remote-SSH to connect to Linux for remote development

Install Remote-SSH and configure it First open yo...

MySQL 5.7.17 winx64 installation and configuration method graphic tutorial

Windows installation mysql-5.7.17-winx64.zip meth...

Two ways to declare private variables in JavaScript

Preface JavaScript is not like other languages ​​...

Remote development with VSCode and SSH

0. Why do we need remote development? When develo...

Solve the problem of MySql8.0 checking transaction isolation level error

Table of contents MySql8.0 View transaction isola...

CSS3 simple cutting carousel picture implementation code

Implementation ideas First, create a parent conta...

How to install and configure Redis in CentOS7

Introduction There is no need to introduce Redis ...

Several ways to easily traverse object properties in JS

Table of contents 1. Self-enumerable properties 2...

Using CSS to implement image frame animation and curve motion

The basic principle of all animations is to displ...

How to wrap HTML title attribute

When I was writing a program a few days ago, I wan...

JavaScript to achieve simple provincial and municipal linkage

This article shares the specific code for JavaScr...

Practical example of Vue virtual list

Table of contents Preface design accomplish summa...

Solution to the problem of data loss when using Replace operation in MySQL

Preface The company's developers used the rep...