DJ. DJ. - 2 months ago 17
MySQL Question

Count table rows

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

Answer
SELECT COUNT(*) FROM fooTable;

will count the number of rows in the table.

See the reference manual.

Comments