At 9:39 -0600 11/8/02, Ray wrote:
is there a way to have mysql skip columns from the data file when loading the
data?
No. You'll be better off preprocessing the file first (or use your
temp file approach; that'll work, too).
i am getting a text delimited data file from an outside source that
is there a way to have mysql skip columns from the data file when loading the
data?
i am getting a text delimited data file from an outside source that is
updated daily. however the data is defined as having 10 blank fields in it,
and in the first 9000 records 7 more fields are just not used,