MySQL Forums
Forum List  »  Perl

Importing a .tsv file into a mysql table
Posted by: Hector Mehta
Date: October 05, 2011 10:13PM

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

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

Options: ReplyQuote

Written By
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.