Top "Rows-affected" questions

How to determine if a MySQL update query succeeded when the data passed in the query is the same as what is already in the database?

Let's say you have a form with pre-populated data from your database, and you allow your users to make changes …

php mysql error-handling rows-affected

Why affected_rows always returns -1?

I seem to have problem getting affected_rows when I INSERT and SELECT, it just returns -1 for some reason? …

php mysqli prepared-statement rows-affected

Getting the number of affected rows for a SQLite statement using the C API

I'm executing a DELETE statement using the SQLite 3 C API, and I'd like to know how to fetch the number …

c sqlite sql-delete rows-affected

UPDATE/DELETE in mysql and get the list of affected row ids?

Is there an efficient way to get the list of affected row IDs (not the # of affected rows via PHP's …

php mysql rows-affected