$query = "LOAD DATA LOCAL INFILE 'email-list.txt' INTO TABLE $tablename FIELDS TERMINATED BY 'r'(email)";

$result = mysqli_query($connection, $query);

xxxx7@yahoo.com
    xxx_xxxxx05@yahoo.com

x
    xxx_xxxxx

FIELDS TERMINATED BY 'r'

FIELDS TERMINATED BY 'r'

FIELDS TERMINATED BY 't' ENCLOSED BY '' ESCAPED BY '\'
LINES TERMINATED BY 'n' STARTING BY ''

TERMINATED BY 'r'(email)";

cricket4877@yahoo.com

TERMINATED BY '/r'(email);