Bug #32022 | Documentation error | ||
---|---|---|---|
Submitted: | 1 Nov 2007 9:31 | Modified: | 5 Nov 2007 10:32 |
Reporter: | Will Chapman | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Query Browser: Docs | Severity: | S3 (Non-critical) |
Version: | OS: | Windows | |
Assigned to: | Peter Lavin | CPU Architecture: | Any |
[1 Nov 2007 9:31]
Will Chapman
[4 Nov 2007 20:12]
Peter Laursen
to my best knowledge double-quotes ( " ) work fine with LOAD DATA INFILE ...
[4 Nov 2007 20:16]
Stefan Hinz
Will: Can you provide a test case where importing data fails when double quotes (") are used?
[5 Nov 2007 9:43]
Will Chapman
On further testing I realise now that the problem was because I was using " to delimit TERMINATED BY strings, for example: LOAD DATA INFILE "c:/sow/httpdocs/dbf/sowmp.csv" INTO TABLE ukmp fields terminated by "," optionally enclosed by '"' LINES TERMINATED BY "\r\n"; My apologies for the false alarm.. Will Chapman Will
[5 Nov 2007 10:32]
Stefan Hinz
Will: I'm closing this as "not a bug". Note: On Windows, please make sure to use the proper path delimiters (normally, backslashes) when referring to files.