In the last episode (Oct 20), Peter J. Schoenster said:
> A cohort wrote a script to import tab delimited files. He uses
> mysqlimport. He uses the -d option to ONLY empty the data from the
> table before importing the new data. My cohort believes that
> mysqlimport is also dropping the table and then recreating the table
> from somewhere and then inserting the new data. And the problem
> according to him is that apparently MySQL is using some older version
> of the table which has a different column structure so that when the
> new data is imported it goes into the wrong columns.
mysqlimport -d does a "DELETE FROM table", which simply removes rows.
To make sure that the data is pulled into the correct fields, you
should use the -c option to mysqlimport and explicitly list the columns
in the same order your input file has them.
--
Dan Nelson
dnelson@stripped
