LOAD DATA INFILE 'file_name.txt'
    INTO TABLE tbl_name 
    FIELDS TERMINATED BY '|' 
    LINES TERMINATED BY '\n'