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]> wrote:
>
> 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)";
> load data file '/foo/test.csv' into table abc.test ('company name')";
>
> i get errs for both of the above...
>
> i can get this to work if i have a column with a single name...
>
> can't find any pointers via google..
>
> any pointers/thoughts/etc...
>
> thanks
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>
>
