Every now and then the question comes up: LOAD DATA indicates a non-zero warning count when I load a file into MySQL; how can I tell which values caused the warnings?
As part of the stuff that's going into the MySQL Cookbook, I've written a program that diagnoses your data file and tells you where the warnings come from. It's a Perl script and requires that you have DBI installed. I'm making an early release available, along with some other scripts from the chapter in the Cookbook concerned with import/export problems. (For example, there's also a script guess_table.pl that looks at a data file and guesses the CREATE TABLE statement you'd need for creating a table to load the data into.) If you want to try these, they're available at: http://www.kitebird.com/mysql-cookbook/ --------------------------------------------------------------------- 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
