Re: ROW_COUNT() returns 0 on INSERT with MySQL ODBC 8.0.12

[Bogdan Degtyariov]

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.