我总是做完

SELECT count(*) FROM table

以上将为您提供所有行的总数.

The above will you give you the total count of all rows.

您可以轻松地附加WHERE子句以获取某些子集的计数

You could just as easily tack on a WHERE clause to get the count of some subset

SELECT count(*) FROM table WHERE foo = 'bar'