2 ms·
Writing "SELECT *" makes it less clear what columns are selected exactly. Explicitly writing what columns shall be returned is more explicit and clear.
by blattimwind 8y ago
Writing "SELECT *" makes it less clear what columns are selected exactly. Explicitly writing what columns shall be returned is more explicit and clear.
- MichaelApproved 8y agoThat's helpful from a code review perspective but it's the performance hit you get with a * select that is the bigger reason to avoid it.
- dahdum 8y agoThe column name conflicts can cause no end of trouble later on as well.