Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

calculate total no of entries in my deta base

Jatinder BediJatinder Bedi indiaPosts: 2

I have a site in which courses, students, affiliations added. on my home page i want to show how many students, affiliations, courses are registered. pls send code to show

Tagged:

Comments

  • VBNETDudeVBNETDude Posts: 6

    That kind of depends...

    The simple, yet slow answer would be:
    SELECT COUNT(*) FROM TABLE_NAME
    This could be slow if you have a lot of entries and the database doesn't keep track of rows.

    You might be able to try a form of:
    SHOW TABLE STATUS;

    A bit of explaining the situation may be in order as far as the structure/type of database...

Sign In or Register to comment.