use following query
SELECT * INTO OUTFILE 'c:/PATH_OF_FILE'
  FIELDS TERMINATED BY ',' FROM 'YOUR_TABLE_NAME';


Regards,
SHAHAJI PATIL

On Thu, Jun 12, 2008 at 10:27 AM, anjali_awatade <[EMAIL PROTECTED]>
wrote:

>   How to create csv file with the records in mysql database?
>
> Plz help...!
>
> Thank you!
>
> 
>


[Non-text portions of this message have been removed]

Reply via email to