ONJava.com -- The Independent Source for Enterprise Java
oreilly.comSafari Books Online.Conferences.

advertisement

AddThis Social Bookmark Button
Article:
  Building a Data Warehouse with MySQL and Perl
Subject:   delimiters
Date:   2007-07-25 10:55:16
From:   awillis
I've found that not using csv at all when loading data into and out of mysql is often easier. SELECT INTO OUTFILE and LOAD DATA INFILE default to tab separated output. If you have text fields that contain tabs, and you can't convert them to spaces, then perhaps I would use a comma delimiter.