Re: REGEXP

[Paul DuBois]

At 18:35 +0200 10/12/02, tl wrote:
>Hello,
>
>mysql>LOAD DATA LOCAL INFILE 'access.log' INTO TABLE tmp FIELDS 
>TERMINATED BY 'REGEXP \"^[ ]{1,}$\"' OPTIONALLY ENCLOSED BY '' 
>ESCAPED BY ' '  LINES TERMINATED BY '\n' ;
>
>How can I make that it would work as I expected?
>How terminate fields by space(s)?

1) You can't specify patterns as file structure indicators.
2) It appears that you want space as the escape character *and* as the
field terminator.  That can't possibly work; it's ambiguous.

>
>Thanks Very much.
>
>Alvydas