From: Martijn van den Burg (Martijn.van.den.Burgasml.com)
Date: Fri Jul 01 2005 - 03:44:54 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hi,

> I have a file where the data looks like this:
>
> "1","23","345","45";
> "34","4","444","1er";
>
> I am then trying to load that data using the load data local
> infile and this statement:
>
> Load data local infile '/httpd/htdocs/sql/loader.sql' into
> table vehicles fields terminated by ',' enclosed by "'" lines
> terminated by ';'

I guess that should be:

Load data local infile '/httpd/htdocs/sql/loader.sql' into table
vehicles fields terminated by ',' enclosed by '"' lines terminated by
'X'; Where 'X' is '\n' when you're on a UNIX/Linux system, '\r' when on
Windows, or '\r\n' when on MacOS.

HTH.

--
Martijn

--
The information contained in this communication and any attachments is confidential and may be privileged, and is for the sole use of the intended recipient(s). Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please notify the sender immediately by replying to this message and destroy all copies of this message and any attachments. ASML is neither liable for the proper and complete transmission of the information contained in this communication, nor for any delay in its receipt.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]