get number of records count in mysql

To get the records count of table in mysql:

SELECT COUNT('fieldname') AS RecordsCount FROM TableName;
(OR)
SELECT COUNT(*) FROM TableName;