Hi Guys, I have been searching for the answer to this question for a while. The answer is so obvious, yet there was no useful source of documentation that showed it. I am using the load data infile syntax rather than the command line utility. To get the warnings the "show warnings" command is sufficient.
mysql> load data infile '/sttn/done/st062020' replace into table mm_stock; Query OK, 2739 rows affected, 21 warnings (0.20 sec) Records: 2739 Deleted: 0 Skipped: 0 Warnings: 21 mysql> show warnings; -Trev -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]