MySQL Forums :: Perl :: Importing a .tsv file into a mysql table
Importing a .tsv file into a mysql table
Posted by: Hector Mehta
Date: October 05, 2011 10:13PM
I have a tab separated file (.tsv) which I would like to import into a table. The file is large (around 11GB) in size with 256 columns.
I tried running the following command from the mysql prompt
LOAD DATA LOCAL INFILE 'importfile.tsv'
INTO TABLE test.destination_table
LINES TERMINATED BY '\n';
and it would only copy the first row of the file.
How do I get the entire data set in ? Alternately, if there is another way to do it thru the Workbench interface - that would be even better. Any suggestions, let me know.
Thanks for your help in advance
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.