Re: SELECT INTO LCOAL OUTFILE

On Thu, Dec 13, 2001 at 12:37:59PM -0500, [EMAIL PROTECTED] wrote: > ello Paul, > > can you try this and let see if it is going to work ! > > UNLOAD DATA FROM TABLE fred INTO LOCAL OUTFILE "file.txt"; > > And if it fails, i am sure somebody their will correct it! Sorry, why would you expect i

Re: SELECT INTO LCOAL OUTFILE

ello Paul, can you try this and let see if it is going to work ! UNLOAD DATA FROM TABLE fred INTO LOCAL OUTFILE "file.txt"; And if it fails, i am sure somebody their will correct it! Regards. kamal >Hi, > >Is there a reason why, if I can > >LOAD DATA LOCAL INFILE 'file' INTO TABLE fred; > >w

Re: SELECT INTO LCOAL OUTFILE

At 8:28 AM +1300 11/28/01, Quentin Bennett wrote: >Hi, > >Is there a reason why, if I can > >LOAD DATA LOCAL INFILE 'file' INTO TABLE fred; > >why I can't > >SELECT * INTO LOCAL OUTFILE '/tmp/file.txt' FROM fred Because it's just never been implemented. > >I know the data has to travel to the cl

SELECT INTO LCOAL OUTFILE

Hi, Is there a reason why, if I can LOAD DATA LOCAL INFILE 'file' INTO TABLE fred; why I can't SELECT * INTO LOCAL OUTFILE '/tmp/file.txt' FROM fred I know the data has to travel to the client, but it would make scripting easier! Quentin Bennett Transport Systems Division Infinity Solutions