MySQL tool navicat batch execution SQL statements

For example: I now want to execute so many statements at the same time 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,"',‘‘);I'll just add a semicolon after each statement, and then I can just click and run and output the result: [sql]update community set XQMC=replace (XQMC,"',‘‘);Affected rows:0Time:1. 450s[sql]update Community Set XQBM=replace (XQBM,"',‘‘);Affected rows:0Time:1. 440s[sql]update Community Set Dkxx=replace (DKXX,"',‘‘);Affected rows:0Time:1. 421s[sql]update Community Set Ssqy=replace (Ssqy,"',‘‘);Affected rows:0Time:1. 557s[sql]update Community Set SSJD=replace (SSJD,"',‘‘);Affected rows:0Time:1. 430s[sql]update Community Set ZHS=replace (ZHS,"',‘‘);Affected rows:0Time:1. 425s[sql]update Community Set CQNX=replace (CQNX,"',‘‘);Affected rows:0Time:1. 432s[sql]update Community Set CQSX=replace (CQSX,"',‘‘);Affected rows:0Time:1. 415s[sql]update Community Set wylb=replace (WYLB,"',‘‘);Affected rows:0Time:1. 433s[sql]update Community Set Wygs=replace (Wygs,"',‘‘);Affected rows:0Time:1. 436s[sql]update Community Set WYF=replace (WYF,"',‘‘);Affected rows:0Time:1. 424s[sql]update Community Set GN=replace (GN,"',‘‘);Affected rows:0Time:1. 428s[sql]update Community Set RQ=replace (RQ,"',‘‘);Affected rows:0Time:1. 439s[sql]update Community Set GS=replace (GS,"',‘‘);Affected rows:0Time:1. 438s[sql]update Community Set GD=replace (GD,"',‘‘);Affected rows:0Time:1. 461s[sql]update Community Set KFS=replace (KFS,"',‘‘);Affected rows:0Time:1. 440s[sql]update Community Set JGSJ=replace (JGSJ,"',‘‘);Affected rows:0Time:1. 449s[sql]update Community Set SC=replace (SC,"',‘‘);Affected rows:1893Time:1. 517s[sql]update Community Set yy=replace (yy,"',‘‘);Affected rows:1743Time:1. 499s[sql]update Community Set YH=replace (YH,"',‘‘);Affected rows:1785Time:1. 527s[sql]update Community Set Yey=replace (Yey,"',‘‘);Affected rows:1094Time:1. 485s[sql]update Community Set Zxx=replace (ZXX,"',‘‘);Affected rows:2342Time:1. 531s[sql]update Community Set DX=replace (DX,"',‘‘);Affected rows:0Time:1. 461s[sql]update Community Set GJ=replace (GJ,"',‘‘);Affected rows:0Time:1. 488s[sql]update Community Set DT=replace (DT,"',‘‘);Affected rows:0Time:1. 432s[sql]update Community Set RJL=replace (RJL,"',‘‘);Affected rows:0Time:1. 421s[sql]update Community Set LHL=replace (LHL,"',‘‘);Affected rows:0Time:1. 428s[sql]update Community Set ZDMJ=replace (ZDMJ,"',‘‘);Affected rows:0Time:1. 443s[sql]update Community Set Jznd=replace (Jznd,"',‘‘);Affected rows:0Time:1. 455s[sql]update Community Set JZMJ=replace (JZMJ,"',‘‘);Affected rows:1Time:1. 456s[sql]update Community Set JZJG=replace (JZJG,"',‘‘);Affected rows:0Time:1. 422s[sql]update Community Set JZLB=replace (JZLB,"',‘‘);Affected rows:0Time:1. 412s[sql]update Community Set CWXX=replace (CWXX,"',‘‘);Affected rows:0Time:1. 443s[sql]update Community Set Xqpt=replace (Xqpt,"',‘‘);Affected rows:1894Time:1. 604s[sql]update Community Set Xqwz=replace (XQWZ,"',‘‘);Affected rows:0Time:1. 609s[sql]update Community Set CS=replace (CS,"',‘‘);Affected rows:0Time:1. 656s[sql]update Community Set URL=replace (URL,"',‘‘);Affected rows:0Time:1.630s

MySQL tool navicat Bulk execution of SQL statements