Chris Lott wrote:
> I am trying to format a file for loading into a MySQL table using the LOAD
> DATA INFILE COMMAND. The data file currently has info as noted below,
> intended for a table with format: (edate DATE, enote LONGTEXT, author
> VARCHAR (80), title VARCHAR (100), quote LONGTEXT):
> <P>A multi-paragraph note field to be inserted into a longtext
> <P>The rest of the paragraph
> Doe, John J.
> The Pickwick Papers Redux
> <P>A multi-paragraph note filed to be inserted into a longtext field.
> <P>Another paragraph of the quote field
> The problem seems to be the multiline fields...
Try the following (not tested!):
LOAD DATA INFILE
TERMINATED BY '\n~~~\n'
TERMINATED BY ''