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

##</code><code>##

mysql> CREATE TABLE jokes ( id int not null, name char(32), timestamp date, joker char(32) );