| 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 | |
[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
http://www.mysql.com/doc/en/Installing_source_tree.html
Thanks for your help.
Right version is
[LINES
[STARTING BY '']
[TERMINATED BY '\n']
]
Description: 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". Tim. How to repeat: