Date conversion and integer truncation during import I am doing some data file imports using:
LOAD DATA
INFILE 'apa.txt'
INTO TABLE Test_Stock_Daily
FIELDS TERMINATED BY ','
(symbol, date, open, high, low, close, volume);

The date in the file is formatted mm/dd/yyyy. I need it to be yyyymmdd in the database.
The volume field needs to be truncated by two places so 123456 becomes 1234.
What are the most SQL-centric ways of doing this?
Table definition
I suggest that this is a bit cleaner than Vérace's answer:

LOAD DATA
    INFILE 'apa.txt'
    INTO TABLE Test_Stock_Daily
    FIELDS TERMINATED BY ','
    (symbol, @date, open, high, low, close, volume)
    SET date = STR_TO_DATE(@date, '%m/%d/%y'); 


(And yes, date is a poor choice for a column name.)