[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Omaha.pm] Quiz: select *




On Jan 30, 2005, at 8:55 PM, Andy Lester wrote:
On Fri, Jan 28, 2005 at 02:38:12PM -0600, Jay Hannah (jhannah@omnihotels.com) wrote:
Quiz: What's wrong with doing "select *" followed by fetchrow_array?

Wrong in which sense?  In the sense that the column order may change in
the future and break your code?

Yes. That was exactly the sense I was looking for. -grin-

Our code lives a long time. Our tables tend to change.

(Plus the less concerning fact that it's wasting CPU cycles on the columns that aren't used.)

j