CODEWITHSUNDEEP
mysqlload-data-infile
caro
caro

Reputation: 892

load data infile format general col type to numeric

I am importing a .csv into a MySql table using LOAD DATA INFILE and would like to find a way around columns containing formatting like "6.10111E+11" -- this should import as "610111447853" but is instead 610111000000. The table col is VARCHAR as sometimes there are letters and those are necessary. Formatting the .csv column as numeric before saving it in the shared location does not seem to work. Can I specify some form of "Set" on that column upon import?

here is my code:

$query = <<<eof
    LOAD DATA LOCAL INFILE '/home/c/Documents/UTC/UTC.csv'
     INTO TABLE UTC_import
    FIELDS TERMINATED BY ',' ENCLOSED BY '"'
  LINES TERMINATED BY '\r\n'
     IGNORE 1 LINES
eof;

Upvotes: 0

Views: 177

Answers (0)

Related Questions