mysql并发sql⼯具_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 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 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
mysql连接工具
[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
受影响的⾏: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

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。