File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and the fly likes Row count in MySQL Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Row count in MySQL" Watch "Row count in MySQL" New topic

Row count in MySQL

aionius dactlys

Joined: Nov 19, 2001
Posts: 4
How can i get the number of rows in a result set? How can i get the returned value of COUNT statment in MySQL?
David O'Meara

Joined: Mar 06, 2001
Posts: 13459

Are you using the mm.mysql Driver? If so, the testsuite/ file has an example of what you are tring to accomplish.
David O'Meara

Joined: Mar 06, 2001
Posts: 13459

The Java Ranch has thousands of visitors every week, many with surprisingly similar names. To avoid confusion we have a naming convention, described at .
We require names to have at least two words, separated by a space, and strongly recommend that you use your full real name. Please log in again with a new name which meets the requirements.
I agree. Here's the link:
subject: Row count in MySQL
Similar Threads
sql script works in mssql but not in mysql
hello everyone,how can i use jsp connect mysql?
Statement stmt SQL syntax error
Hibernate metadata property problem
Retrieve MySQL table column names