Explain in detail the usage of the COUNT function in MySQL and the mysqlcount Function

Explain in detail the usage of the COUNT function in MySQL and the mysqlcount Function

The COUNT function of MySQL is the simplest function and is very useful for calculation. The number of records returned by a SELECT statement is expected.

The tables of the EMPLOYEE_TBL to be considered by the COUNT function have the following records:

mysql> SELECT * FROM employee_tbl;+------+------+------------+--------------------+| id  | name | work_date | daily_typing_pages |+------+------+------------+--------------------+|  1 | John | 2007-01-24 |        250 ||  2 | Ram | 2007-05-27 |        220 ||  3 | Jack | 2007-05-06 |        170 ||  3 | Jack | 2007-04-06 |        100 ||  4 | Jill | 2007-04-06 |        220 ||  5 | Zara | 2007-06-06 |        300 ||  5 | Zara | 2007-02-06 |        350 |+------+------+------------+--------------------+7 rows in set (0.00 sec)

To calculate the number of rows in the preceding table, you can make the following assumptions:

mysql>SELECT COUNT(*) FROM employee_tbl ;+----------+| COUNT(*) |+----------+|    7 |+----------+1 row in set (0.01 sec)

Similarly, if you want to count one, you can calculate the number of Zara records as follows:

mysql>SELECT COUNT(*) FROM employee_tbl  -> WHERE name="Zara";+----------+| COUNT(*) |+----------+|    2 |+----------+1 row in set (0.04 sec)

Note: All SQL queries are case-sensitive, so there is no difference, if you give ZARA or Zara IN THE where condition.