RE: please help out

2003-10-28 Thread Tom Horstmann
> Now, how can I save only these 1000++ data into a file in my pc? Normaly you should get the data into a file with that something you sent the query to mysql with. What is that something in your case? Regards, TomH -- PROSOFT EDV-Lösungen GmbH & Co. KG Geschäftsführer: Axel-Wilhelm Wegmann AG

Re: please help out

2003-10-28 Thread Nitin
me/data.txt" Nitin - Original Message - From: "Pey Ling" <[EMAIL PROTECTED]> To: "Nitin" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, October 28, 2003 3:31 PM Subject: Re: please help out > Hi, how to write this :"full path an

Re: please help out

2003-10-28 Thread Pey Ling
Hi, how to write this :"full path and file name"? can i copy it to my local pc rather than the server? best regards, Pey Ling From: "Nitin" <[EMAIL PROTECTED]> To: "Pey Ling" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, October 28, 20

Re: please help out

2003-10-28 Thread Nitin
Easy, use:'select * INTO OUTFILE "full path and file name" FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY "\n" from user where race='chinese' and state='US'Nitin- Original Message - From: "Pey Ling" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, October