Running import works, but the clerk_id's are being written to the column as 1,2,3 vs 001, 002, 003. How can i get it to retain the original data? The clerk id needs to be 3 digits.
The mysql table structure indicates that clerk_id field is set to INT(11) with no attributes.
Why is it doing this?
LOAD DATA LOCAL INFILE '~/import_companies.csv'INTO TABLE companiesFIELDS TERMINATED BY ','LINES TERMINATED BY '\n'(company_id,clerk_id);