in reply to Re^2: MySQL row_count and DBI
in thread MySQL row_count and DBI

Ah, but now I've tried an on duplicate key update where the update didn't actually change anything (the value to update to was there already), and select row_count() gave 0, but execute returned 1. So they're not always the same.

(The query was insert foo(bar)value(1)on duplicate key update baz=1; and the table already had 1 in each column.)

$_="msh210";$"=$\;@_=@{[split//,uc]}[2,0];$_="@_$\1";$\=$/;++$_[0]for$...1;print lc substr crypt($_,"@_"),1,6