Reading from a file into MySQL

Basic load, there's lots more options for column delimiters, line delimiters, etc...

LOAD DATA INFILE '/tmp/mydata.txt' INTO TABLE Test;