Mysql: Dumping data to a file

To dump data into a comma separated file use this:

  SELECT * INTO OUTFILE 'tablename.csv'
  FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
  LINES TERMINATED BY 'n'
  FROM tablename;

Replace tablename with the tablename of the table you which to dump to a file.

This entry was posted on 2007/01/01, 20:59 and is filed under databases, Development. You can follow any responses to this entry through RSS 2.0. You can leave a response, or trackback from your own site.

Netfactory