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
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)";