DJ. DJ. - 1 year ago 86
MySQL Question

Count table rows

What is the MySQL command to retrieve the count of records in a table?

Answer Source
SELECT COUNT(*) FROM fooTable;

will count the number of rows in the table.

See the reference manual.