Count

Find the count of employees from the employees table:

mysql> SELECT COUNT(*) FROM employees;+----------+| COUNT(*) |+----------+|   300024 |+----------+1 row in set (0.03 sec)

Get MySQL 8 Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.