Import CSV file with numeric data

[wally0001]

I am trying to import a CSV file which was exported from another mysql database with comma separation and quote delimeters. A numeric column is enclosed in quotes and cannot be directly imported into the target table since it is now a string.

How should I import this data? I have tried to import it to an intermediate table with the id column defined as a varchar but I have been unable to convert that value back to a number.

Any suggestions?

 

[TonyGroves]

You should be able to import it no problem if you use something like:
[tt]
LOAD DATA LOCAL INFILE '/path/myfile.csv'
INTO TABLE mytable
FIELDS TERMINATED BY ',' ENCLOSED BY '"'
[/tt]