|
|
Posted by David Gillen on 08/04/07 14:30
Jerry Stuckle said:
> 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.
>
I didn't pose the original question. Also it's peoples php code where the
problem seems to lie, i.e. in the code being unable to handle changing of the
order of the columns.
D.
--
Fermat was right.
Navigation:
[Reply to this message]
|