3 ms·
While SELECT * has no place in a production code, it's the right thing to do during data exploration with ad hoc queries. Only after I get sufficient understan
by jerzyt 6y ago
While SELECT * has no place in a production code, it's the right thing to do during data exploration with ad hoc queries. Only after I get sufficient understanding of the data, I'll restrict the columns.
I often see junior developers assume what they need just by the name of the columns, and miss something.
Oh wait, I just did that a few days ago. It was embarrassing.
- ttz 6y agoUsing LIMIT N is a great habit to develop to prevent yourself from hogging resources too, during exploration.