my dog learned polymorphism*
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
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Row count in MySQL" Watch "Row count in MySQL" New topic
Author

Row count in MySQL

aionius dactlys
Greenhorn

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
Rancher

Joined: Mar 06, 2001
Posts: 13459

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

Joined: Mar 06, 2001
Posts: 13459

"aionius",
The Java Ranch has thousands of visitors every week, many with surprisingly similar names. To avoid confusion we have a naming convention, described at http://www.javaranch.com/name.jsp .
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.
Thanks.
Dave.
 
 
subject: Row count in MySQL