my dog learned polymorphism*
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


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
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
 
jQuery in Action, 2nd edition
 
subject: how get the total of record in database by sql
 
Similar Threads
RMI update issue
rms size
java heap size out of memory error
About Urly Bird 1.2.0
query the record from database and display it in XML