Load CSV file to MySQL

In many cases it is very convenient to import CSV files directly into the database, so it can be analyzed, referred to and other useful actions. MySQL’s can easily load tables from files, using the LOAD DATA INFILE command, but its default separators do not match the CSV format. Here is the LOAD command, fitted to load CSV files:

LOAD DATA INFILE '/tmp/file.csv'
INTO TABLE the_table
FIELDS
TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'

Comments

• Tags

  csv design patterns dll hell ejb3 freebsd fun hibernate java javascript jaxb jboss jconsole jmx linux merlin u760 mysql novatel rmi schema seam sed source control tips ubuntu visitor visualvm wireless modem worldmate live xjc xml

• Recent Posts

  • Advanced OpenSocial Development
  • JAXB and creating elements from schema types
  • Douglas Crockford: "Advanced JavaScript"
  • Douglas Crockford: "The JavaScript Programming Language"
  • Pigeon: Impossible

• Recent Comments

  • Joan on JMX remote monitoring on Linux
  • Samuel Van Reeth on JAXB and creating elements from schema types
  • Samuel Van Reeth on JAXB and creating elements from schema types
  • Frood on Live patterns: Switching to the visitor design pattern
  • Petar Ivanov on JMX remote monitoring on Linux