Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Difference in between mysql_num_rows and mysql_affected_rows

Tags:

mysql

mysqldump

I want to know what is the difference in between mysql_num_rows and mysql_affected_rows.How to know when it should use.Any help and suggestions will be highly appreciable.Examples are most welcome.

like image 498
NewUser Avatar asked Mar 08 '12 12:03

NewUser

Video Answer

1 Answers

Use mysql_num_rows for SELECT queries while mysql_affected_rows for UPDATE and DELETE queries.

  • mysql_num_rows tells you how many records were returned from a SELECT query
  • mysql_affected_rows tells you how many rows were UPDATEed or DELETEed
like image 144
Sarfraz Avatar answered Oct 02 '22 16:10

Sarfraz
Sign in to Comment

Related questions

prevent $_POST bombing
MySQL - suggestions to append data to an existing field/record?
mysql: use SET or lots of columns?
Fill dataGrid from MySQL database in C# WPF
Linking MySQL Workbench to my Remote Server
Check if mySQL record added in the last x seconds
Displaying message when no results found in PHP MySQL search
Retrieving all the content of a MySQL query to Jade template engine through NodeJS and Express
PHP how to specify "back one directory level" in an url
MySQL INSERT - Do field names require backtick/accent delimination?
PostgreSQL csv import from a MySQL csv export?
MySQL LIKE %string% not quite forgiving enough. Anything else I can use?
MySQL non primary foreign key
MySQL Procedure within a Select?
Speeding up perl DBI fetchrow_hashref
How to filter rows based on the character length of a field
MySQL fetch array adds duplicate values?
Java MYSQL/JDBC query is returning stale data from cached Connection
Is my mysql.general_log table getting too big?
MySQL retrieve latest record for Group

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!