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
Yes, I simply don't understand this:
===
LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name.txt'
[REPLACE | IGNORE]
INTO TABLE tbl_name
[FIELDS
[TERMINATED BY '\t']
[[OPTIONALLY] ENCLOSED BY '']
[ESCAPED BY '\\' ]
]
[LINES
[ST
I also have it prepared like this:
"1","Mac","SE30","314784","LOV","115","","",""
"2","Mac","Performa6300CD","338211","LOV","109","","",""
Also, I did have all the "\" as "\N" previously.
But what about at the end of lines. What I had with "\N" wouldn't take
so I was hoping someone might out wh
Ted-
check out
http://www.mysql.com/doc/en/LOAD_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
Subj
