Comments - SELECT

9 years, 3 months ago Daniel Black

It seems equally as bad as select *. There's a number of reasons why select * are bad - http://www.parseerror.com/blog/select-*-is-evil . There are exceptions to this rule (like every rule) but it in generally using select * is a common way to incur a software maintenance debt. It also can force the db to retrieve more data than needed, and in doing, so miss out on query optimisations to get your data quicker (if you don't actually need all columns).

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.