I get a data feed over which I have no influence WRT format.
It comes with dates specified as mm/dd/yyyy.
I'd wanted to use something like the following statement to load the
data, but the date format is a problem.
LOAD DATA INFILE 'C:/data/myfeedfile.txt' INTO TABLE mytable;
I get an error message like "Incorrect date value: '11/22/1999' for
column 'start_date' at row 1"
Can I tell MySQL to interpret the date in the format provided as a date
and be confident that it will do so properly? If so, how? In other
words, if mm/dd/yyyy is not a valid date, ...