批量执行mysql工具_mysql工具Navicat批量执行SQL语句

例如：我现在要同时执行这么多语句

update community set xqmc=replace(xqmc,‘

‘,‘‘);

update community set xqbm=replace(xqbm,‘

‘,‘‘);

update community set dkxx=replace(dkxx,‘

‘,‘‘);

update community set ssqy=replace(ssqy,‘

‘,‘‘);

update community set ssjd=replace(ssjd,‘

‘,‘‘);

update community set zhs=replace(zhs,‘

‘,‘‘);

update community set cqnx=replace(cqnx,‘

‘,‘‘);

update community set cqsx=replace(cqsx,‘

‘,‘‘);

update community set wylb=replace(wylb,‘

‘,‘‘);

update community set wygs=replace(wygs,‘

‘,‘‘);

update community set wyf=replace(wyf,‘

‘,‘‘);

update community set gn=replace(gn,‘

‘,‘‘);

update community set rq=replace(rq,‘

‘,‘‘);

update community set gs=replace(gs,‘

‘,‘‘);

update community set gd=replace(gd,‘

‘,‘‘);

update community set kfs=replace(kfs,‘

‘,‘‘);

update community set jgsj=replace(jgsj,‘

‘,‘‘);

update community set sc=replace(sc,‘

‘,‘‘);

update community set yy=replace(yy,‘

‘,‘‘);

update community set yh=replace(yh,‘

‘,‘‘);

update community set yey=replace(yey,‘

‘,‘‘);

update community set zxx=replace(zxx,‘

‘,‘‘);

update community set dx=replace(dx,‘

‘,‘‘);

update community set gj=replace(gj,‘

‘,‘‘);

update community set dt=replace(dt,‘

‘,‘‘);

update community set rjl=replace(rjl,‘

‘,‘‘);

update community set lhl=replace(lhl,‘

‘,‘‘);

update community set zdmj=replace(zdmj,‘

‘,‘‘);

update community set jznd=replace(jznd,‘

‘,‘‘);

update community set jzmj=replace(jzmj,‘

‘,‘‘);

update community set jzjg=replace(jzjg,‘

‘,‘‘);

update community set jzlb=replace(jzlb,‘

‘,‘‘);

update community set cwxx=replace(cwxx,‘

‘,‘‘);

update community set xqpt=replace(xqpt,‘

‘,‘‘);

update community set xqwz=replace(xqwz,‘

‘,‘‘);

update community set cs=replace(cs,‘

‘,‘‘);

update community set url=replace(url,‘

‘,‘‘);

我只要在每条语句后面加个分号 ； 就可以直接点击运行然后输出结果

结果：

[SQL]update community set xqmc=replace(xqmc,‘

‘,‘‘);

受影响的行:0时间:1.450s

[SQL]

update community set xqbm=replace(xqbm,‘

‘,‘‘);

受影响的行:0时间:1.440s

[SQL]

update community set dkxx=replace(dkxx,‘

‘,‘‘);

受影响的行:0时间:1.421s

[SQL]

update community set ssqy=replace(ssqy,‘

‘,‘‘);

受影响的行:0时间:1.557s

[SQL]

update community set ssjd=replace(ssjd,‘

‘,‘‘);

受影响的行:0时间:1.430s

[SQL]

update community set zhs=replace(zhs,‘

‘,‘‘);

受影响的行:0时间:1.425s

[SQL]

update community set cqnx=replace(cqnx,‘

‘,‘‘);

受影响的行:0时间:1.432s

[SQL]

update community set cqsx=replace(cqsx,‘

‘,‘‘);

受影响的行:0时间:1.415s

[SQL]

update community set wylb=replace(wylb,‘

‘,‘‘);

受影响的行:0时间:1.433s

[SQL]

update community set wygs=replace(wygs,‘

‘,‘‘);

受影响的行:0时间:1.436s

[SQL]

update community set wyf=replace(wyf,‘

‘,‘‘);

受影响的行:0时间:1.424s

[SQL]

update community set gn=replace(gn,‘

‘,‘‘);

受影响的行:0时间:1.428s

[SQL]

update community set rq=replace(rq,‘

‘,‘‘);

受影响的行:0时间:1.439s

[SQL]

update community set gs=replace(gs,‘

‘,‘‘);

受影响的行:0时间:1.438s

[SQL]

update community set gd=replace(gd,‘

‘,‘‘);

受影响的行:0时间:1.461s

[SQL]

update community set kfs=replace(kfs,‘

‘,‘‘);

受影响的行:0时间:1.440s

[SQL]

update community set jgsj=replace(jgsj,‘

‘,‘‘);

受影响的行:0时间:1.449s

[SQL]

update community set sc=replace(sc,‘

‘,‘‘);

受影响的行:1893时间:1.517s

[SQL]

update community set yy=replace(yy,‘

‘,‘‘);

受影响的行:1743时间:1.499s

[SQL]

update community set yh=replace(yh,‘

‘,‘‘);

受影响的行:1785时间:1.527s

[SQL]

update community set yey=replace(yey,‘

‘,‘‘);

受影响的行:1094时间:1.485s

[SQL]

update community set zxx=replace(zxx,‘

‘,‘‘);

受影响的行:2342时间:1.531s

[SQL]

update community set dx=replace(dx,‘

‘,‘‘);

受影响的行:0时间:1.461s

[SQL]

update community set gj=replace(gj,‘

‘,‘‘);

受影响的行:0时间:1.488s

[SQL]

update community set dt=replace(dt,‘

‘,‘‘);

受影响的行:0时间:1.432s

[SQL]

update community set rjl=replace(rjl,‘

‘,‘‘);

受影响的行:0时间:1.421s

[SQL]

update community set lhl=replace(lhl,‘

‘,‘‘);

受影响的行:0时间:1.428s

[SQL]

update community set zdmj=replace(zdmj,‘

‘,‘‘);

受影响的行:0时间:1.443s

[SQL]

update community set jznd=replace(jznd,‘

‘,‘‘);

受影响的行:0时间:1.455s

[SQL]

update community set jzmj=replace(jzmj,‘

‘,‘‘);

受影响的行:1时间:1.456s

[SQL]

update community set jzjg=replace(jzjg,‘

‘,‘‘);

受影响的行:0时间:1.422s

[SQL]

update community set jzlb=replace(jzlb,‘

‘,‘‘);

受影响的行:0时间:1.412s

[SQL]

update community set cwxx=replace(cwxx,‘

‘,‘‘);

受影响的行:0时间:1.443s

[SQL]

update community set xqpt=replace(xqpt,‘

‘,‘‘);

受影响的行:1894时间:1.604s

[SQL]

update community set xqwz=replace(xqwz,‘

‘,‘‘);

受影响的行:0时间:1.609s

[SQL]

update community set cs=replace(cs,‘

‘,‘‘);

受影响的行:0时间:1.656s

[SQL]

update community set url=replace(url,‘

‘,‘‘);

受影响的行:0时间:1.630s