Gerald L. Clark wrote:
Mark Nienberg wrote:
I'm trying to use LOAD DATA INFILE to read a csv formatted file into a
mysql 5.0.22 table. Some of the fields contain text that has newline
characters in it. After reading the manual to learn how special
characters are treated, I altered the csv fi
Mark Nienberg wrote:
I'm trying to use LOAD DATA INFILE to read a csv formatted file into a
mysql 5.0.22 table. Some of the fields contain text that has newline
characters in it. After reading the manual to learn how special
characters are treated, I altered the csv file so newlines are
repr
I'm trying to use LOAD DATA INFILE to read a csv formatted file into a mysql 5.0.22
table. Some of the fields contain text that has newline characters in it. After
reading the manual to learn how special characters are treated, I altered the csv
file so newlines are represented by '\\n', that