Posted by Jerry Stuckle on 08/03/07 18:12

David Gillen wrote:
> 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.

Just because it's a follow on question doesn't mean it should be here.

You'll get much better answers in comp.databases.mysql - where all the
people are MySQL users, and some of the MySQL development team hang out.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[Back to original message]