Hello, This is what I'm trying to do: load data local infile 'file.txt' into table mytable fields optionally enclosed by '"' escaped by '"' terminated by ','
My file looks like this 1,"data1" 2,"data2" 3,"data3" etc my table is defined with (id integer not null, data varchar(200) not null). The command only inserts one row, which contains all the data concatenated into my data column... ie select * from mytable | id | data | | 1 | "data1 2,data2 3,data3 1 row in set, since all the data is being entered into the first row (concatenated to 200 chars). Can someone tell me what I'm doing wrong? Thanks, Chris Book [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
