total « Record « Java Database Q&A

1. total records in a result set

2. Count total number of records in database

Ok, for a single table, to count the number of rows you issue: select count(*) from mytable But to count the number of rows in your entire database (do you really need to know this?), you first need to determine the tables, and then issue the same select statement above. To find the names of tables in a database is usually ...

3. How to get total records