批量删除有规则的表_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
声明:本网页内容旨在传播知识,若有侵权等问题请及时与本网联系,我们将在第一时间删除处理。TEL:177 7030 7066 E-MAIL:11247931@qq.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