aspose file tools*
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
 
Consider Paul's rocket mass heater.
 
subject: how get the total of record in database by sql