Number of Rows Selected or Affected in MySQL

Home > MySQL

Q

How To Get the Number of Rows Selected or Affected by a SQL Statement in MySQL?

✍: FYIcenter.com

A

There are two functions you can use the get the number of rows selected or affected by a SQL statement:

mysql_num_rows($res) - Returns the number of rows selected in a result set object returned from SELECT statement.
mysql_affected_rows() - Returns the number of rows affected by the last INSERT, UPDATE or DELETE statement.

⇒ Inserting Data into an Existing Table in MySQL

⇐ Creating a New Table in MySQL

⇑ Managing Tables and Running Queries with PHP for MySQL

⇑⇑ MySQL Database Tutorials

2017-10-08, 2735🔥, 0💬

Looping through Query Output Rows in MySQL
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and loop through the returning rows is to run the SELECT statement with the mysql_query() function, catch the returning object as a result set, and loop through the result with the mysql_fetch_assoc() func... 2017-06-28, 9038🔥, 0💬

Managing Tables and Running Queries with PHP for MySQL
Where to find answers to frequently asked questions on Managing Tables and Running Queries with PHP for MySQL? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Managing Tables and Running Queries with PHP for MySQL. Clear explanations and tutorial ... 2017-10-08, 3255🔥, 0💬

What Is a Result Set Object in MySQL
What Is a Result Set Object in MySQL? A result set object is a logical representation of data rows returned by mysql_query() function on SELECT statements. Every result set object has an internal pointer used to identify the current row in the result set. Once you get a result set object, you can us... 2017-09-20, 3147🔥, 0💬

Selecting an Existing Database in MySQL
How To Select an Exiting Database in MySQL? The first thing after you have created a connection object to the MySQL server is to select the database where your tables are located, by using the mysql_select_db() function. If your MySQL server is offered by your Web hosting company, they will assign a... 2017-10-23, 2840🔥, 0💬

Creating a New Table in MySQL
How To Create a New Table in MySQL? If you want to create a table, you can run the CREATE TABLE statement as shown in the following sample script: <?php include "mysql_connection.php"; $sql = "CREATE TABLE fyi_links (" . " id INTEGER NOT NULL" . ", url VARCHAR(80) NOT NULL" . ", notes VARCHAR... 2017-10-08, 2795🔥, 0💬

Inserting Data into an Existing Table in MySQL
How To Insert Data into an Existing Table in MySQL? If you want to insert a row of data into an existing table, you can use the INSERT INTO statement as shown in the following sample script: <?php include "mysql_connection.php"; $sql = "INSERT INTO fyi_links (id, url) VALUES (" . " 101, 'dev.... 2017-10-08, 2794🔥, 0💬

Selecting Other User's Database in MySQL
Can You Select Someone Else Database in MySQL? If your MySQL server is provided by an Internet service company, they will provide you one database for your use only. There are many other databases on the server for other users. But your user account will have no privilege to select other databases. ... 2017-10-23, 2767🔥, 0💬

Number of Rows Selected or Affected in MySQL
How To Get the Number of Rows Selected or Affected by a SQL Statement in MySQL? There are two functions you can use the get the number of rows selected or affected by a SQL statement: mysql_num_rows($res) - Returns the number of rows selected in a result set object returned from SELECT statement. my... 2017-10-08, 2736🔥, 0💬

Execute SQL Statements in MySQL
How To Execute a SQL Statement in MySQL? You can run any types of SQL statements through the mysql_query() function. It takes the SQL statement as a string and returns different types of data depending on the SQL statement type and execution status: Returning FALSE, if the execution failed. Returnin... 2017-10-23, 2732🔥, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.