Women in Technology

Hear us Roar



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.