The way I do this is within PHP is to echo the value stored in mysql_error after each SQL statement. If you're not using PHP then this probably doesn't help though ;-)
Cheers Andrew. ----- Original Message ----- From: "Bob Lockie" <[EMAIL PROTECTED]> To: "MySQL Mailing List" <[EMAIL PROTECTED]> Sent: Wednesday, June 30, 2004 3:38 PM Subject: debug > 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. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
