This week's giveaway is in the EJB and other Java EE Technologies forum.
We're giving away four copies of EJB 3 in Action and have Debu Panda, Reza Rahman, Ryan Cuprak, and Michael Remijan 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


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies 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: 15286
    
    6

Moving to JDBC.


GenRocket - A Test Data Generation Platform
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: how get the total of record in database by sql
 
Similar Threads
RMI update issue
java heap size out of memory error
rms size
query the record from database and display it in XML
About Urly Bird 1.2.0