|
|
Posted by Jerry Stuckle on 08/04/07 17:44
David Gillen wrote:
> 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.
Nope, its ANY code, not just PHP.
And NOTHING in the last 20-30 posts in this thread have ANYTHING to do
with PHP. It's been all MySQL.
Please take this somewhere appropriate. It is no longer appropriate to
this newsgroup.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|