this.
load data local infile '' into table
fields
terminated by ',' optionally enclosed by '"';
This is what I used and it worked very well.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 27, 2003 8:31 PM
To: MyS
_DATA.html
(go to mysql prompt and issue command LOAD DATA INFILE)
keeping attention to format for INFILE
Hth,
Martin
- Original Message -
From: <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Tuesday, May 27, 2003 9:25 PM
Subject: help with load from file
H
r MySQL and that should import rather well.
But like I said I am sure someone out there has a much better solution
then
the one I mentioned.
Steve
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 27, 2003 7:26 PM
To: MySQL List
Subject: help with load
, May 27, 2003 9:25 PM
Subject: help with load from file
> Hi,
>
> I have a text file where lines look like this:
>
> 3 Mac Performa6300CD 338211 LOV 109 \ \ \
> 4 Mac G3BT/266 350755 LOV 003 \ 9.1 104.103
>
> Except they are not wrapped like in this email!
> Each co
Hi,
I have a text file where lines look like this:
3 Mac Performa6300CD 338211 LOV 109 \ \ \
4 Mac G3BT/266350755 LOV 003 \ 9.1 104.103
Except they are not wrapped like in this email!
Each column