|
Posted by The Natural Philosopher on 01/21/08 13:48
Jerry Stuckle wrote:
> Willem Bogaerts wrote:
>>> 4) Never ask for more data then you're really sure you're going to use.
>>> The numerous times I've seen 'SELECT *' in production code...
>>> --Rik Wasmus
>>
>> Ah, that would be my code. I never put more fields in a table than I'm
>> interested in. So SELECT * gives me exactly all fields I'm interested
>> in...
>>
>> Regards,
>
> It's still not a good idea to use SELECT *. What happens if the next
> programmer comes along and adds a 10Mb BLOB column to the table and
> stuffs 10MB images in it?
>
One had better hope he also adjusts the myqsql calls ;-)
Navigation:
[Reply to this message]
|