mysql> LOAD DATA LOCAL INFILE '/path/to/datafile.txt' INTO TABLE table_name;