有多台服务器 上面有 一百来个数据库 每个数据库的表结构一样 现在全部数据库都要执行两句相同的语句 请教一下该怎么来解决 ?有什么好的方法
附(执行语句): delete FROM `ecs_goods_custome_attr_value` where `attr_value`='Please select your size';
delete FROM `ecs_goods_custome_attr_value` where `attr_value`='';
附(执行语句): delete FROM `ecs_goods_custome_attr_value` where `attr_value`='Please select your size';
delete FROM `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`='';
information_schema里面有所有的库,表名称等信息。