total number of rows?

mysql> SELECT COUNT(*) FROM table;