mysql select the count of records code example

Example: select count from table mysql

SELECT COUNT(*) FROM count_demos;