At 22:35 -0800 1/27/02, Chris Williams wrote:
>I'm trying to create a LOAD statement that will enable me to load both a
>comma or tab delimited text file. I am only successful in achieving one or
>the other by using:
> "LOAD DATA LOCAL INFILE mfile.txt INTO TABLE Temp FIELDS TERMINATED BY
>'\\t,' LINES TERMINATED BY '\\r\\n'
>or
>"LOAD DATA LOCAL INFILE mfile.txt INTO TABLE Temp FIELDS TERMINATED BY ','
>LINES TERMINATED BY '\\r\\n'
>
>I don't know however the proper syntax to include both field termination
>parameters in one LOAD statement
You can't.
> like I am able to do with line termination.
You can't do that either. Your statements don't describe a termination
string that's one or the other, they describe a termination string that
requires both.
>
>Regards,
>Chris Williams
