Skip to content

Instantly share code, notes, and snippets.

@t11a

t11a/mysql_load_data_local_infile.rb

Created March 6, 2013 10:31
Show Gist options
  • Save t11a/5098403 to your computer and use it in GitHub Desktop.
Save t11a/5098403 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
mysql_load_data_local_infile.rb
sql = "LOAD DATA LOCAL INFILE '#{csv_file}' INTO TABLE tblname FIELDS TERMINATED BY ',' LINES TERMINATED BY '\\n'"
ActiveRecord::Base.connection.execute(sql)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment