Page 1 of 1

Find total amount of rows

Posted: Wed Oct 12, 2005 5:28 pm
by Luke
What is the best way to find the total amount of rows in a table in a mysql database?

Posted: Wed Oct 12, 2005 5:30 pm
by pickle

Code: Select all

SELECT 
  count(*) as 'total rows'
FROM
  whatever_table_you_want

Posted: Wed Oct 12, 2005 5:54 pm
by Luke
thanks.