how to Return total number of rows

mysql> SELECT COUNT(*) FROM tablename;