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
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
