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
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Databases » JDBC
Reply 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
Ranch Hand

Joined: Jul 11, 2001
Posts: 15230

Moving to JDBC.
 
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: how get the total of record in database by sql
 
Similar Threads
About Urly Bird 1.2.0
java heap size out of memory error
query the record from database and display it in XML
RMI update issue
rms size