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
>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, and 1 field
>that is encrypted and useless to me. there are about 140 fields total in this
>table.
>
>i already could write an awk/sed script to clean up stuff, and its possible
>to use a temp_table as well and do a insert select as well. but i'm
>wondering if there is a way in MySQL 3.23 to do this already. (if its built
>in, why hack it together with scripts?)
>
>--
>mysql, sql, query
>
