mySQL: How do I find the number of rows in my table

 How do I find the number of rows in my table?

In mySQL:

select count(*) from enron.message;

or

show table status;

SQL Server:

use enron;

go

select count(*) from dbo.message;

or

use enron;

go

select * from sys.partitions where object_id = OBJECT_ID('dbo.message');