Posted by David Gillen on 08/03/07 14:16

Gary L Burnore said:
> I'm thinking he's not having this discussion in comp.databases.mysql
> because he knows what the response will be. He was hoping he wouldn't
> get the same response here. :)

The discussion is being had here because it follows on from a question asked.
I've also yet to see a valid reason as to why select * shouldn't be used on a
single table query when you want all fields from that table other than
1) you can't depend on the order of the fields return. Which is irrelevant if
you write your code so that you need not be concerned with that.
2) vague rumbling about the mysql team advising against it, although I'm
having difficulting finding that on the mysql site, and I'm guessing this
really relates to complex joins and the order of returned results. Both of
which do not affect the situation I posed.

D.
--
Fermat was right.

[Back to original message]