Re: mysql - load data file question..

2008-06-28 Thread Ananda Kumar
can u please show use the content of the test.csv file. Also is "comapny name" a single column or two different columns If its two different columns than try this load data file '/foo/test.csv' into table abc.test fields terminated by ',' (company,name)"; On 6/28/08, bruce <[EMAIL PROTECTED]> w

mysql - load data file question..

2008-06-27 Thread bruce
Hi.. I've got an issue with doing a Load data file" cmd.. my test text tbl has a column named "company name" i'm trying to figure out how to use the load data file cmd, to be able to extract the "company name" col... when i do: load data file '/foo/test.csv' into table abc.test (company name)";