Meaningless Drivel is fun!*
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

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