Re: Inserting a new column in between.

[Thomas Kellerer <spam_eater(at)gmx(dot)net>]

RPK wrote on 25.02.2007 09:44:
> Select * from tablename;
>
> the un-necessary field gets displayed in the last. However, you I can ignore
> that field altogether using filtered fields only in Select statement, but
> still sometimes it is necessary.
No it's not. SELECT * should be avoided by all means (except for ad-hoc queries).

Thomas