Counting and Selecting Group Records MySql Terminal Commands

To count and select group records in terminal use this command. #terminal #mysql

SELECT *, (SELECT COUNT([column]) FROM [table]) AS count FROM [table] GROUP BY [column];