Database Star
Do you use SELECT * in production code?I never use it in production queries.Why?- It can return more columns than you need.- The order of columns might change- It makes queries harder to maintainInstead, I specify the columns that I actually want.I do, however, use SELECT * when exploring data or trying to understand what's in a table.What about you?
1 month ago | [YT] | 48
Database Star
Do you use SELECT * in production code?
I never use it in production queries.
Why?
- It can return more columns than you need.
- The order of columns might change
- It makes queries harder to maintain
Instead, I specify the columns that I actually want.
I do, however, use SELECT * when exploring data or trying to understand what's in a table.
What about you?
1 month ago | [YT] | 48