On Wed, May 09, 2001 at 10:51:44AM -0400, Bill Moran wrote:
> Peter Pentchev wrote:
> > So, MySQL 3.22.x does not have the capability to produce dumpfiles,
> > only outfiles.
> >
> > Ah. I just read the whole of your message. You are using a 3.22.32 server -
> > so, sorry, but you're out of luc
Peter Pentchev wrote:
> So, MySQL 3.22.x does not have the capability to produce dumpfiles,
> only outfiles.
>
> Ah. I just read the whole of your message. You are using a 3.22.32 server -
> so, sorry, but you're out of luck :(
A Curses, I was hoping to avoid an upgrade (since we've ha
y:
> >
> > 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 :)
> >
>
om' clauses :)
>
> G'luck,
> Peter
>
> --
> I am the thought you are now thinking.
>
> > Robin Keech wrote:
> > >
> > > use
> > > SELECT * INTO OUTFILE 'filename' .
> > >
> > > -Original Message-
>
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
> &
hat I need.
Any other suggestions?
-Bill
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 u
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 syn
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 m
