mysql工具Navicat批量执行SQL语句
2024-08-21 02:21:21
例如:我现在要同时执行这么多语句 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
最新文章
- node模块函数图解
- ECMAScript数据类型
- sql操作table
- linux关于bashrc与profile的区别(转)
- (转)JS中公共/私有变量和方法
- Android插件简介
- python3操作socketserver
- 学习string,stringBuffer时遇到的问题
- vue定义全局组件
- mysql插入报主键冲突,解决方法主键索引重新排序
- python第四天 三级菜单新思路
- js重定向跳转页面
- EF延迟加载和懒加载
- 函数的有用信息,装饰器 day12
- Ubuntu几种常见乱码解决方法
- poj1321 DFS
- BZOJ4317: Atm的树
- call_user_func_array 应用场景分析
- iOS-UIView一些坐标和位置方法封装
- Effective STL 学习笔记 32 ~ 33