***BOGO*** mysql - load data file question..

["bruce" <bedouglas@xxxxxxxxxxxxx>]

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/mysql?unsub=royale@xxxxxxxxxx