select count with * query in mysql code example

Example: select count from table mysql

SELECT COUNT(*) FROM count_demos;