my sql get count code example

Example: select count from table mysql

SELECT COUNT(*) FROM count_demos;