Bulk Delete and modify MySQL tables for specific prefixes

Bulk delete a specific prefix table

First step: Assemble SQL statements

Select CONCAT (' drop table ', table_name, '; ') From Information_schema.tables Where table_name like ' ca_% ';

650) this.width=650; "src=" Https://s5.51cto.com/wyfs02/M02/00/48/wKiom1majyzxbuLhAAAcE0BJqZk929.png "title=" 2017-08-21_153020.png "alt=" Wkiom1majyzxbulhaaace0bjqzk929.png "/>

The second step: the contents of the red box selected copy and paste execution can be

Tip: To uncheck the vertical bar (|), ALT + the left mouse button is a column selection so you can check the contents of the red box

Bulk Modify Table prefixes

First step: Assemble SQL statements

Select Concat (' ALTER TABLE ', TABLE_NAME, ' Rename to Cj_ ', substring (table_name,5), '; ') from Information_schema.tables Where table_name like ' xws_% ';

The second step: check the copy and paste results, execute can

This article is from the "Technology" blog, so be sure to keep this source http://hywds.blog.51cto.com/13158032/1958058

Bulk Delete and modify MySQL tables for specific prefixes