MySQL allows you to quickly delete all tables without deleting databases.

Source: Internet
Author: User

MySQL allows you to quickly delete all tables without deleting databases.

This example describes how MySQL can quickly delete all tables without deleting databases. We will share this with you for your reference. The details are as follows:

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

This section describes how to quickly delete a data table using SQL commands.

Command to delete a table:

Drop table name;

If you have 200 tables and execute them for 200 times, you don't want to do it.

The following provides a solution to use the information_schema database:
Copy codeThe Code is as follows: select concat ('drop table', table_name, ';') FROM information_schema. 'tables 'where table_schema = 'database name ';

Use this command to obtainDrop table name;Such statements are then executed in batches.

Check the execution result and remove the first line. The following is to delete all tables in the dede system.

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

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;

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.