count operator in mysql

count operator is use for count the row in the table.

mysql> SELECT COUNT(*) FROM tablename;