Load Data Doesn't Work?

LOAD DATA INFILE works fine normally, but will not work fot this table:

CREATE TABLE search_cat(
title VARCHAR (70) not null,
place VARCHAR (200) not null);

An example of the file being loaded:
"Acting","Arts/Performing_Arts/"
"Genres","Arts/"
"Horror","Arts/Genres/"

And resulting data is entered as:
--------------------------------------------------------------
Regional | Arts/Performing_Arts/" "Acting*|
Genres | Arts/" "Horror |
Science_Fiction_and_Fantasy | Arts/Genres/" "Art* |
--------------------------------------------------------------

Any idea to why this is not loading properly?


Thank you.
yoshi
datera@datera.com http://www.datera.com

[This message has been edited by yoshi (edited September 25, 2000).]

I could be totally wrong, but I don't think you need to put text values in quotes for LOAD DATA INFILE. Also, I thought that command worked for tab-delmited files, I've never tried to feed it a file that used commas as delimters?

Yes you can use all different methods for load data infile

Make sure you are using :-
FIELDS ENCLOSED BY '"' FIELDS TERMINATED BY ','

Regards
Darren http://www.php4hosting.com/ $ http://www.php4hosting.co.uk/ £
PHP/MySQL Hosting from under $5

word.