This week's book giveaway is in the OCPJP forum.
We're giving away four copies of OCA/OCP Java SE 7 Programmer I & II Study Guide and have Kathy Sierra & Bert Bates on-line!
See this thread for details.
The moose likes JDBC and the fly likes how get the total of record in database by sql Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "how get the total of record in database by sql" Watch "how get the total of record in database by sql" New topic
Author

how get the total of record in database by sql

Soo Samuel
Greenhorn

Joined: Jan 02, 2005
Posts: 4
need get help...
how get the total of record of our table in the database....
Mike Litherland
Ranch Hand

Joined: Aug 12, 2004
Posts: 31
Hi,

Not really a java topic, but "select count(*) from `table`" should do what you need.

Mike
Gregg Bolinger
GenRocket Founder
Ranch Hand

Joined: Jul 11, 2001
Posts: 15299
    
    6

Moving to JDBC.


GenRocket - Experts at Building Test Data
 
 
subject: how get the total of record in database by sql