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
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
