


Share the implementation method of MySQL quickly deleting all tables without deleting the database
Sep 14, 2017 am 11:28 AMThis 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 |
|
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 |
|
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!

Hot Article

Hot tools Tags

Hot Article

Hot Article Tags

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

PHP's big data structure processing skills

How to optimize MySQL query performance in PHP?

How to use MySQL backup and restore in PHP?

How to insert data into a MySQL table using PHP?

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 use MySQL stored procedures in PHP?

Performance optimization strategies for PHP array paging
