SELECT /*!40001 SQL_NO_CACHE */ * INTO OUTFILE '/tmp/ClientActionTrack2015112511.txt' 不堵塞事务
2024-09-01 18:45:11
mysql> insert into ClientActionTrack20151125(clientSn,ip,url,httpMethod,requestParams,requestHeader,pageUrl,sessionId,startTime,completeTime) values(11,'1.1.1.1',NULL,' 用户注册-register-成功',NULL,NULL,NULL,NULL,now(),now());
Query OK, 1 row affected (0.03 sec) mysql> select * from ClientActionTrack20151125 where ipd='1.1.1.1';
ERROR 1054 (42S22): Unknown column 'ipd' in 'where clause'
mysql> select * from ClientActionTrack20151125 where ip='1.1.1.1'; insert into ClientActionTrack20151125(clientSn,ip,url,httpMethod,requestParams,requestHeader,pageUrl,sessionId,startTime,completeTime) select clientSn,ip,url,httpMethod,requestParams,requestHeader,pageUrl,sessionId,startTime,completeTime from ClientActionTrack20151125; SELECT /*!40001 SQL_NO_CACHE */ * INTO OUTFILE '/tmp/ClientActionTrack20151125.txt' /*!50138 CHARACTER SET binary */ FROM `ClientActionTrack20151125`; Session 1:
mysql> SELECT /*!40001 SQL_NO_CACHE */ * INTO OUTFILE '/tmp/ClientActionTrack2015112511.txt' /*!50138 CHARACTER SET binary */ FROM `ClientActionTrack20151125`; Session 2: mysql> insert into ClientActionTrack20151125(clientSn,ip,url,httpMethod,requestParams,requestHeader,pageUrl,sessionId,startTime,completeTime) values(11,'1.1.1.1',NULL,' 用户注册-register-成功',NULL,NULL,NULL,NULL,now(),now());
Query OK, 1 row affected (0.00 sec) mysql> commit;
Query OK, 0 rows affected (0.00 sec) 不堵塞事务
最新文章
- TFS 测试用例步骤数据统计
- curl 小结
- Android Service完全解析,关于服务你所需知道的一切(上)
- MSCRM 修改 默认组织
- 【CodeForces 227A】Where do I Turn?叉积
- ligerui多选动态下拉框
- angularjs探秘<;一>;
- Go Cookie 练习
- 解决IE6下a标签的onclick事件里的超链接不跳转问题
- absolute元素 text-align属性
- DataBase MongoDB高级知识-易使用
- 芝麻HTTP:redis-py的安装
- LVDS、CVBS
- C# 窗体打开拖动到窗体的文件
- iftop流量监控工具
- Ubuntu 16.04.3 LTS 安装 MongoDB
- springboot集成quartz定时任务课动态执行
- springboot Redis 缓存
- Qt setMouseTracking(true) 无效
- nginx 模块及运行机制 第三章