4 ms·
Absolutely this was drummed into me 20+ years ago when I worked on my first major sql based project
by Mauricebranagh 6y ago
Absolutely this was drummed into me 20+ years ago when I worked on my first major sql based project
- GekkePrutser 6y agoBut that argument only holds true of you rely on the column order. Most modern applications just specify column names where this doesn't matter. A lot of best practices from 20 years ago are no longer valid. Like the excessive normalisation. These days data storage isn't always the major limiting factor anymore, in many cases it's better to have less tables with more data.
- deleted 6y ago[deleted]
- Mauricebranagh 6y agoWell if your specifying columns your not by definition doing a select *
- GekkePrutser 6y agoI meant specifying columns during extraction of the rows. Like using name=result_row("name") instead of name=result_row(1) The former works even with SELECT * irrespective of the order of the columns. The latter won't.