多个数据库(Mysql)要执行 两具相同的SQL语句

有多台服务器 上面有 一百来个数据库 每个数据库的表结构一样 现在全部数据库都要执行两句相同的语句 请教一下该怎么来解决 ?有什么好的方法 


附(执行语句):

  delete FROM `ecs_goods_custome_attr_value` where `attr_value`='Please select your size';
  delete FROM `ecs_goods_custome_attr_value` where `attr_value`='';

没有好办法，如果仅是一次性清理任务。 则你可以在EXCEL中生成这些语句，然后直接贴入MYSQL工具运行。 你可以用show databases 得到所有数据库名，贴入EXCEL第一列，然后将不需要的数据库删除后，利用公式得到如下语句。

delete FROM db1.`ecs_goods_custome_attr_value` where `attr_value`='Please select your size'; delete FROM db1.`ecs_goods_custome_attr_value` where `attr_value`='';
delete FROM db2.`ecs_goods_custome_attr_value` where `attr_value`='Please select your size'; delete FROM db2.`ecs_goods_custome_attr_value` where `attr_value`='';
delete FROM db3.`ecs_goods_custome_attr_value` where `attr_value`='Please select your size'; delete FROM db3.`ecs_goods_custome_attr_value` where `attr_value`='';
delete FROM db4.`ecs_goods_custome_attr_value` where `attr_value`='Please select your size'; delete FROM db4.`ecs_goods_custome_attr_value` where `attr_value`='';
delete FROM db5.`ecs_goods_custome_attr_value` where `attr_value`='Please select your size'; delete FROM db5.`ecs_goods_custome_attr_value` where `attr_value`='';
delete FROM db6.`ecs_goods_custome_attr_value` where `attr_value`='Please select your size'; delete FROM db6.`ecs_goods_custome_attr_value` where `attr_value`='';
delete FROM db7.`ecs_goods_custome_attr_value` where `attr_value`='Please select your size'; delete FROM db7.`ecs_goods_custome_attr_value` where `attr_value`='';
delete FROM db8.`ecs_goods_custome_attr_value` where `attr_value`='Please select your size'; delete FROM db8.`ecs_goods_custome_attr_value` where `attr_value`='';
delete FROM db9.`ecs_goods_custome_attr_value` where `attr_value`='Please select your size'; delete FROM db9.`ecs_goods_custome_attr_value` where `attr_value`='';
delete FROM db10.`ecs_goods_custome_attr_value` where `attr_value`='Please select your size'; delete FROM db10.`ecs_goods_custome_attr_value` where `attr_value`='';
delete FROM db11.`ecs_goods_custome_attr_value` where `attr_value`='Please select your size'; delete FROM db11.`ecs_goods_custome_attr_value` where `attr_value`='';
delete FROM db12.`ecs_goods_custome_attr_value` where `attr_value`='Please select your size'; delete FROM db12.`ecs_goods_custome_attr_value` where `attr_value`='';
delete FROM db13.`ecs_goods_custome_attr_value` where `attr_value`='Please select your size'; delete FROM db13.`ecs_goods_custome_attr_value` where `attr_value`='';
delete FROM db14.`ecs_goods_custome_attr_value` where `attr_value`='Please select your size'; delete FROM db14.`ecs_goods_custome_attr_value` where `attr_value`='';
delete FROM db15.`ecs_goods_custome_attr_value` where `attr_value`='Please select your size'; delete FROM db15.`ecs_goods_custome_attr_value` where `attr_value`='';
delete FROM db16.`ecs_goods_custome_attr_value` where `attr_value`='Please select your size'; delete FROM db16.`ecs_goods_custome_attr_value` where `attr_value`='';
delete FROM db17.`ecs_goods_custome_attr_value` where `attr_value`='Please select your size'; delete FROM db17.`ecs_goods_custome_attr_value` where `attr_value`='';
delete FROM db18.`ecs_goods_custome_attr_value` where `attr_value`='Please select your size'; delete FROM db18.`ecs_goods_custome_attr_value` where `attr_value`='';
delete FROM db19.`ecs_goods_custome_attr_value` where `attr_value`='Please select your size'; delete FROM db19.`ecs_goods_custome_attr_value` where `attr_value`='';
delete FROM db20.`ecs_goods_custome_attr_value` where `attr_value`='Please select your size'; delete FROM db20.`ecs_goods_custome_attr_value` where `attr_value`='';

没有简便的方法，在各个服务器上 删除 OR 安装 FEDERATED，建立FEDERATED表，再删除

是删除一部分数据 不是删除表

去information_schme拼个语句出来