Why SELECT * is always not a right choice?

SELECT * might be the most famous (or used) mysql/postgres command out there. But is it that simple under the hood? Test on not-so-big table between SELECT and SELECT COUNT( *) Consider a table person having 627 rows (quite small, eh?) Let's test th...