Definition: The MySQL Count command is used to count the number of records held on a specific table in your database. It is phrased as: SELECT COUNT(*) FROM table_name;
Examples:
SELECT COUNT(*) FROM icecream;
This would count the number of records in the table called 'icecream'.
