Exporting from MySQL indicating the terminator
USE <database_name>; SELECT * INTO OUTFILE "<file_name.txt>" FIELD TERMINATED BY '' FROM <table_name>;