Originally Posted by psili

Look up "load data infile".... off the top of my head, and not checking syntax, it would look something like:

mysql>load data in file 'data.txt' into table [table_name] fields terminated by '|' lines terminated by '\n' ignore 1 lines