MySQL batch delete table _ MySQL

MySQL batch delete table bitsCN.com

MySQL batch delete tables

There is no existing tool in mysql for direct implementation, so the principle is to use the existing function to implement automatic spelling of drop table statements, so as to simplify the purpose.

The following example shows how to delete a table starting with "wp:

1 Select CONCAT ('drop table', table_name, ';') 2 FROM information_schema.tables3Where table_name LIKE 'WP _ % ';

In this way, all the statements of drop table wp_xxxx will appear. copy the statements, modify them, and paste them directly to the command line to run them.

BitsCN.com