批量删除有规则的表_MySQL
来源：懂视网
责编：小采
时间：2020-11-09 18:49:01
批量删除有规则的表_MySQL
批量删除有规则的表_MySQL:bitsCN.com 批量删除有规则的表 echo select concat('drop table ', table_name ,';') from tables where table_schema='hadoop_xxxx' and table_name like 'ad_first
导读批量删除有规则的表_MySQL:bitsCN.com 批量删除有规则的表 echo select concat('drop table ', table_name ,';') from tables where table_schema='hadoop_xxxx' and table_name like 'ad_first
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
批量删除有规则的表_MySQL
批量删除有规则的表_MySQL:bitsCN.com 批量删除有规则的表 echo select concat('drop table ', table_name ,';') from tables where table_schema='hadoop_xxxx' and table_name like 'ad_first
