This Post below ↓ is only visible to you.
It is sheduled to delete with all the changelog & comment data attached. You can cancel deletion at any time.

How to delete all tables with prefix: 'prefix_' with 1 query?

How to delete all tables with prefix: 'prefix_' with 1 query?Edit

Andrzej Jeziorski · 431 user posts · 26 user answers

1. GENERATE the statement 
 
<code>SELECT CONCAT( 'DROP TABLE ', GROUP_CONCAT(table_name) , ';' ) AS statement FROM information_schema.tables WHERE table_name LIKE 'prefix_%';</code> 
 
2. PASTE the statement into SQL query. 
 
<code>MySQL is a relational database management system (RDBMS)[1] that runs as a server providing multi-user access to a number of databases. MySQL is officially pronounced /ma???skju???l/ ("My S-Q-L"),[2] but is often also pronounced /ma??si?kw?l/ ("My Sequel"). It is named for original developer Michael Widenius' daughter My. The SQL phrase stands for Structured Query Language.[3] 
The MySQL development project has made its source code available under the terms of the GNU General Public License, as well as under a variety of proprietary agreements. MySQL was owned and sponsored by a single for-profit firm, the Swedish company MySQL AB, now owned by Oracle Corporation.[4] 
Members of the MySQL community have created several forks (variations) such as Drizzle, OurDelta, Percona Server, and MariaDB. All of these forks were in progress before the Oracle acquisition; Drizzle was announced eight months before the Sun acquisition. 
Free-software projects that require a full-featured database management system often use MySQL. Such projects include (for example) WordPress, phpBB, Drupal and other software built on the LAMP software stack. MySQL is also used in many high-profile, large-scale World Wide Web products, including Wikipedia, Google[5] and Facebook.[6] 
 
source: en.wikipedia.org/wiki/MySQL</code>

Cancel

1. GENERATE the statement

SELECT CONCAT( 'DROP TABLE ', GROUP_CONCAT(table_name) , ';' ) AS statement FROM information_schema.tables WHERE table_name LIKE 'prefix_%';

2. PASTE the statement into SQL query.

MySQL is a relational database management system (RDBMS)[1] that runs as a server providing multi-user access to a number of databases. MySQL is officially pronounced /ma???skju???l/ ("My S-Q-L"),[2] but is often also pronounced /ma??si?kw?l/ ("My Sequel"). It is named for original developer Michael Widenius' daughter My. The SQL phrase stands for Structured
Query Language.[3]

The MySQL development project has made its source code available under the terms of the GNU General Public License, as well as under a variety of proprietary agreements. MySQL was owned and sponsored by a single for-profit firm, the Swedish company MySQL AB, now owned by Oracle Corporation.[4]

Members of the MySQL community have created several forks (variations) such as Drizzle, OurDelta, Percona Server, and MariaDB. All of these forks were in progress before the Oracle acquisition; Drizzle was announced eight months before the Sun acquisition.

Free-software projects that require a full-featured database management system often use MySQL. Such projects include (for example) WordPress, phpBB, Drupal and other software built on the LAMP software stack. MySQL is also used in many high-profile, large-scale World Wide Web products, including Wikipedia, Google[5] and Facebook.[6]



source: en.wikipedia.org/wiki/MySQL

Edit