On Thu, Jan 24, 2002 at 01:48:58PM +0100, Paul van den Berg wrote: > Hello list, > > the regular mysql-client returns some useful information after > batch-inserts like: > > Query OK, 11393 rows affected (0.47 sec) > Records: 11393 Duplicates: 0 Warnings: 0 > > I can fetch the number of effected rows in perl/DBI with $sth->rows, > > but is it possible to fetch the count of duplicates and warnings, or > even the time that the query took to process?
The timing is done by the client (I'm pretty sure), so you might want to use Perl's Time::HiRes module to figure out how much time has elapsed. I also recall hearing that there are plan on the drawing board for making it easier to programmatically access warnings and errors after batch inserts. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 22 days, processed 514,527,539 queries (266/sec. avg) --------------------------------------------------------------------- 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
