Getting the number of Rows from a MySQL table using Java

Question

I've seen a lot of similar questions which try to achieve this by using a while loop to count the entries. But I was hoping that there would be a way similar to this which could work? String SQL = "SELECT Name FROM (table name) TABLE WHERE SCHEMA

    PreparedStatement statement = conn.prepareStatement(SQL);
    ResultSet a = statement.executeQuery();
    System.out.println(a);

`select count(foo) from bar` + `int numRows = result.getInt(1)` in a separate query would work without much data traffic and without a loop — dly, Aug 19 '15 at 11:07
possible duplicate of [Get Number of Rows returned by ResultSet in Java](http://stackoverflow.com/questions/8292256/get-number-of-rows-returned-by-resultset-in-java) — Jordi Castilla, Aug 19 '15 at 11:09

Uma Kanth · Answer 1 · 2015-08-19T11:00:16.473

1

Maybe you could use count.

SELECT COUNT(column_name) FROM table_name;

Or you could do it using a variable.

int count = 0;
while(rs.next())
  count ++;

edited Aug 19 '15 at 11:00

answered Aug 19 '15 at 10:58

Uma Kanth

5,659
2
20
41

he will have to query again to get the data – Danyal Sandeelo Aug 19 '15 at 10:59

score 0 · Answer 2 · edited May 23 '17 at 12:29

0

ResultSet.last() followed by ResultSet.getRow() will give you the row count, but it may not be a good idea as it can mean reading the entire table over the network and throwing away the data

if(rs.last()){
   rowCount = rs.getRow(); 
   rs.beforeFirst();
}

via : How do I get the size of a java.sql.ResultSet?

edited May 23 '17 at 12:29

Community

1
1

answered Aug 19 '15 at 11:00

Danyal Sandeelo

12,196
10
47
78

Getting the number of Rows from a MySQL table using Java

2 Answers2