免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 1775 | 回复: 0

mysql :select into outfile 很慢 zz [复制链接]

论坛徽章:
0
发表于 2011-12-19 13:55 |显示全部楼层

Hey everyone,

I’m running into trouble using SELECT ... INTO OUTFILE

Here’s the query I’m running:
SELECT * INTO OUTFILE ‘c:\\temp\\test.txt’
FROM `db`.`table`
WHERE dateTime = ‘2009-12-09 16:45:35’;

I get the following error:
The query includes syntax that is not supported by the Infobright Optimizer. Either restructure the query with supported syntax, or enable the MySQL Query Path in the brighthouse.ini file to execute the query with reduced performance.

I understand that a resolution is explained in the error, but I would rather not break out of the infobright optimizer.. How do I need to restructure my query so it uses supported syntax?


解决办法:

Hooray, that did the trick! For posterity, I just had to run this query:

set @bh_dataformat 'txt_variable'

After that, the previously mentioned queries worked.

您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

SACC2019中国系统架构师大会

【数字转型 架构演进】SACC2019中国系统架构师大会,7折限时优惠重磅来袭!
2019年10月31日~11月2日第11届中国系统架构师大会(SACC2019)将在北京隆重召开。四大主线并行的演讲模式,1个主会场、20个技术专场、超千人参与的会议规模,100+来自互联网、金融、制造业、电商等领域的嘉宾阵容,将为广大参会者提供一场最具价值的技术交流盛会。

限时七折期:2019年8月31日前


----------------------------------------

大会官网>>
  

北京盛拓优讯信息技术有限公司. 版权所有 16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122
中国互联网协会会员  联系我们:huangweiwei@it168.com
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP