Importing a .tsv file into a mysql table
Hi All,
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
hector
Subject
Written By
Posted
Importing a .tsv file into a mysql table
October 05, 2011 10:13PM
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.