On Wed, May 09, 2001 at 09:20:52AM -0400, Bill Moran wrote:
> Thanks for the reply, but I need a binary transfer of the DATA in the
> field only. INTO OUTFILE does 2 things that corrupt the data:
> 1. Puts field data in the file
> 2. Escapes characters.
>
> As far as I can tell, I either have to use "INTO DUMPFILE" or I need to
> write a C program to do what I need.
> Any other suggestions?
The MySQL manual says:
SELECT [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RES\
ULT]
[HIGH_PRIORITY]
[DISTINCT | DISTINCTROW | ALL]
select_expression,...
[INTO {OUTFILE | DUMPFILE} 'file_name' export_options]
[FROM table_references
So try:
SELECT resume INTO DUMPFILE '/data/file.doc' FROM apps WHERE appid=23
In other words, just move the 'INTO DUMPFILE' part where it belongs,
just after the expression, before any 'from' clauses :)
G'luck,
Peter
--
I am the thought you are now thinking.
> Robin Keech wrote:
> >
> > use
> > SELECT * INTO OUTFILE 'filename' .....
> >
> > -----Original Message-----
> > From: Bill Moran [mailto:[EMAIL PROTECTED]]
> > Sent: 09 May 2001 00:44
> > To: [EMAIL PROTECTED]
> > Subject: Problem using "SELECT INTO DUMPFILE"
> >
> > I get an error stating: "you have an error in your SQL syntax near
> > 'dumpfile '/data/file.doc''"
> >
> > The command I'm trying to execute is:
> > select resume from apps where appid=23 into dumpfile '/data/file.doc'
> > The server and client are on two different computers.
> >
> > I'm using client version 3.23.36 on machine redfs
> > Server version 3.22.32 on machine redsql
> >
> > Do I need to upgrade the server before this will be possible? I
> > understand that SELECT INTO DUMPFILE must put the file on the local
> > machine, but does that mean when running the client on redfs, I'm trying
> > to put the file on redsql? (just thought of this, but it would be weird
> > to get that particular error if that were the case) That wouldn't work,
> > since there is no /data directory on redsql. If that's the problem, I
> > suppose I'll have to establish a NFS mount.
> >
> > Any pointers are welcome. Please keep me in the CC box as I'm not
> > currently subscribed to this list.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
