How can we find the number of rows in a MySQL table?

By Mysql

SELECT COUNT(*) FROM table_name;