FOUND_ROWS() Function for Total Number of Rows Affected in MySQL - MySQL Developer Tutorial

FOUND_ROWS() Function for Total Number of Rows Affected in MySQL

If you want to know how many rows are affected by last statement in MySQL in given sessions, you can use FOUND_ROWS() function.

Let's say we have a table customer with below definition and some sample records.

CREATE TABLE `customer` (
  `idcustomer` int,
  `firstname` varchar(50)  NULL,
  `lastname` varchar(30)  NULL,
  `age` int(11) DEFAULT NULL,
  `phonenumber` char(11) DEFAULT NULL,
  `dob` date DEFAULT NULL,
  `gender` char(1) NOT NULL
) ;

insert into customer(idcustomer,firstname,lastname,age,phonenumber,dob,gender)

Now you can run any statement and then we can run Found_Rows() function to check how many rows are affected.

If we simple run select statement on  customer table.

Select * from customer;

The above query has returned use 4 rows from customer table. We can check the rows affected by above query by using FOUND_ROWS() function.

Select FOUND_ROWS();

use FOUND_ROWS() Function to get rows affected by last statement


  1. Hey, everybody. My family and I recently moved, and we needed a quick and reliable way to find a new home. With the help of high quality modular homes we found the perfect solution! This site provided us with a huge selection of modular homes in a variety of styles and sizes, making it easy for us to find something that was perfect for our needs. The buying process was simple and transparent, and we are looking forward to starting a new chapter of our lives in our beautiful modular home!