MySQL Forums
Forum List  »  Connector/ODBC

Re: ROW_COUNT() returns 0 on INSERT with MySQL ODBC 8.0.12
Posted by: Bogdan Degtyariov
Date: October 22, 2018 12:32AM

Hi Ben,

Sorry it took too long time to reply, but better late than never.

Your problem might be related to matched/affected rows in UPDATE.

You can try adding "FOUND_ROWS=1" to your connection string or set the same through the ODBC Administrator DSN Setup GUI Dialog (Details >> Cursors/Results >> [x]Return matched rows instead of affected rows).

This option works as follows: when you run an update operation it finds rows matching the update criteria, but the actual update is only done to those rows where the data changes. If update sets the same value, which is already is there, such row is not counted as "affected", so you might get the row count lower than expected. Setting FOUND_ROWS=1 results in returning the number for all rows matching the update criteria even if some of them did not have to be updated.

I hope this helps.

Options: ReplyQuote

Written By
Re: ROW_COUNT() returns 0 on INSERT with MySQL ODBC 8.0.12
October 22, 2018 12:32AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.