Home Database Mysql Tutorial Share the implementation method of MySQL quickly deleting all tables without deleting the database

Share the implementation method of MySQL quickly deleting all tables without deleting the database

Sep 14, 2017 am 11:28 AM
mysql fast

This article mainly introduces the method of MySQL to quickly delete all tables without deleting the database. It involves the related operation skills of mysql batch execution statements. Friends in need can refer to the following

The examples of this article describe the implementation of MySQL A quick way to delete all tables without deleting the database. Share it with everyone for your reference, the details are as follows:

If you use phpmyadmin directly to operate it, it will definitely be very simple. Check the data table-"Click to delete-"Click OK, the operation is completed!

Here we introduce the SQL command operation method to quickly delete the data table.

Command to delete tables:


1

drop table 表名;

Copy after login

If there are 200 tables, execute it 200 times, and you won’t want to do it just thinking about it.

The following provides a solution using the information_schema library:

Copy code The code is as follows:

SELECT CONCAT('drop table ',table_name ,';') FROM information_schema.`TABLES` WHERE table_schema='database name';

Use this command to get statements like drop table table name;, 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 dede as the default table prefix, you can directly copy the following command and execute it.


1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

74

75

76

77

78

79

80

81

82

83

84

85

86

87

88

89

90

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;

Copy after login

The above is the detailed content of Share the implementation method of MySQL quickly deleting all tables without deleting the database. For more information, please follow other related articles on the PHP Chinese website!

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot Article Tags

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

PHP's big data structure processing skills PHP's big data structure processing skills May 08, 2024 am 10:24 AM

PHP's big data structure processing skills

How to optimize MySQL query performance in PHP? How to optimize MySQL query performance in PHP? Jun 03, 2024 pm 08:11 PM

How to optimize MySQL query performance in PHP?

How to use MySQL backup and restore in PHP? How to use MySQL backup and restore in PHP? Jun 03, 2024 pm 12:19 PM

How to use MySQL backup and restore in PHP?

How to insert data into a MySQL table using PHP? How to insert data into a MySQL table using PHP? Jun 02, 2024 pm 02:26 PM

How to insert data into a MySQL table using PHP?

What are the application scenarios of Java enumeration types in databases? What are the application scenarios of Java enumeration types in databases? May 05, 2024 am 09:06 AM

What are the application scenarios of Java enumeration types in databases?

How to fix mysql_native_password not loaded errors on MySQL 8.4 How to fix mysql_native_password not loaded errors on MySQL 8.4 Dec 09, 2024 am 11:42 AM

How to fix mysql_native_password not loaded errors on MySQL 8.4

How to use MySQL stored procedures in PHP? How to use MySQL stored procedures in PHP? Jun 02, 2024 pm 02:13 PM

How to use MySQL stored procedures in PHP?

Performance optimization strategies for PHP array paging Performance optimization strategies for PHP array paging May 02, 2024 am 09:27 AM

Performance optimization strategies for PHP array paging

See all articles