MySQL tool navicat batch execution SQL statements

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.