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]