Bug #456 LOAD DATA INFILE: bad wording of parameter
Submitted: 20 May 2003 4:41 Modified: 27 May 2003 3:29
Reporter: Lenz Grimmer Email Updates:
Status: Closed Impact on me:
Category:MySQL Server Severity:S3 (Non-critical)
Version: OS:
Assigned to: CPU Architecture:Any

[20 May 2003 4:41] Lenz Grimmer
Please consider changing "LINES STARTING BY" with "LINES STARTING WITH" or "LINES STARTED BY" 
instead, as suggested by Tim Bunce: 
> ChangeSet 
>   1.365 03/05/20 04:09:15 monty@narttu.mysql.fi +1 -0 
>   Updated information about LOAD DATA .. LINES STARTING BY 
> @@ -37971,6 +37970,7 @@ 
>          [ESCAPED BY '\\' ] 
>      ] 
>      [LINES TERMINATED BY '\n'] 
> +    [LINES STARTING BY ''] 
>      [IGNORE number LINES] 
>      [(col_name,...)] 
>  @end example 
> @@ -38107,6 +38107,9 @@ 
>  as windows uses two characters as a line terminator. Some programs, like 
>  @code{worldpad}, may use @code{\r} as a line terminator. 
My previous email pointing out a number of problems, including the 
worldpad typo above, has not been acted on. 
> +If @code{LINES STARTING BY prefix} is used, read until prefix is found 
> +and start reading at character after prefix.  If line doesn't include prefix 
> +it will be skipped. 
In English that would read much better as "LINES STARTING WITH" or 
perhaps "LINES STARTED BY". 

How to repeat:
[27 May 2003 3:29] Victor Vagin
Thank you for your bug report. This issue has been fixed in the latest
development tree for that product. You can find more information about
accessing our development trees at 

Thanks for your help.
Right version is

        [STARTING BY '']
        [TERMINATED BY '\n']