Count table rows

SELECT COUNT(*) FROM fooTable;

will count the number of rows in the table.

See the reference manual.