Bug #32022 Documentation error

• Submitted: 1 Nov 2007 9:31
• Modified: 5 Nov 2007 10:32
• Reporter: Will Chapman
• Status: Not a Bug
• Category: MySQL Query Browser: Docs
• Severity: S3 (Non-critical)
• OS: Windows
• Assigned to: Peter Lavin
• CPU Architecture: Any

[1 Nov 2007 9:31] Will Chapman

Description:
The section on Migrating a Spreadsheet into MySQL contains incorrect code samples
that use " as text delimiters rather than '.

For example, in the chapter A.5. Loading the Data into a MySQL Database Table, the following use of delimiters creates errors:

LOAD DATA INFILE “/home/peter/Documents/spreadsheet/data.tsv” INTO TABLE alldata; 

How to repeat:
As above

Suggested fix:
Change " delimiters to '

[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.