3 messages in com.mysql.lists.mysqldebug
FromSent OnAttachments
Bob Lockie30 Jun 2004 07:38 
Andrew Pattison30 Jun 2004 11:46 
Bob Lockie02 Jul 2004 07:05 
Subject:debug
From:Bob Lockie (bjlo@lockie.ca)
Date:06/30/2004 07:38:37 AM
List:com.mysql.lists.mysql

I'm running a ton of sql statements to load data.

Is there a way to not display successes: Query OK, 1 row affected (0.02 sec) Records: 1 Duplicates: 0 Warnings: 0

and display failures and the query statement that failed?

There are 60 000+ of these and I'd ideally like to debug the inserts without actually doing them.

It fails on duplicate keys but I have no idea where the data is flawed.