Chinaunix首页 | 论坛 | 博客
  • 博客访问: 472515
  • 博文数量: 41
  • 博客积分: 4007
  • 博客等级: 中校
  • 技术积分: 725
  • 用 户 组: 普通用户
  • 注册时间: 2006-09-30 15:43
文章分类

全部博文(41)

文章存档

2011年(13)

2010年(14)

2009年(2)

2008年(12)

分类: Mysql/postgreSQL

2011-01-18 10:55:56

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.

阅读(1540) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~