Find total amount of rows
Posted: Wed Oct 12, 2005 5:28 pm
What is the best way to find the total amount of rows in a table in a mysql database?
A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/
Code: Select all
SELECT
count(*) as 'total rows'
FROM
whatever_table_you_want