例如：我现在要同时执行这么多语句
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