Jump to content

Get total number of rows


Recommended Posts

How do I get the total number of rows without actually selecting everything in the table? I want to get the total number of rows in a table to use it in PHP, it's a big table with ~200k rows (i can see that using heidisql) and i don't want to do SELECT * because that would be very inefficient.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...