批量删除有规则的表_MySQL
程序员文章站
2022-06-17 12:56:10
...
bitsCN.com
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