search

Home >Database >Mysql Tutorial >批量删除有规则的表_MySQL

批量删除有规则的表_MySQL

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
2016-06-01 13:28:201074browse

bitsCN.com


批量删除有规则的表

 

echo "select concat('drop table ',  table_name ,';') from tables where table_schema='hadoop_xxxx' and table_name like 'ad_first_url_%';" | mysql information_schema | sed -n '2,$p' | mysql hadoop_xxxx

 


bitsCN.com
Statement：
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
Previous article：mysql图形管理工具mysqlphpadm安装_MySQLNext article：如何使用索引提高查询速度_MySQL

Related articles

See more