sql question

Jonathan Ellis jonathan at carnageblender.com
Tue Jul 12 16:15:44 MDT 2005


On Tue, 12 Jul 2005 16:11:05 -0600, "Merrill Oveson" <moveson at gmail.com>
said:
> Anybody know of sql statement where I can select all the columns
> except one or two.
> 
> I.e.  Instead of this:
> 
>    select a,b,c,d,e,f,g,h,i,j,k,l,m,n from foo
> 
> I could do this:
>  
>    select *, except m,n from foo
> 
> possible?
> 
> I'm using sqlserver and mysql

There isn't one.  Using "select *" is usually considered poor form since
someone reading your code has to refer to the table definition to see
what comes back; the same would apply to your hypothetical statement as
well.

-Jonathan



More information about the PLUG mailing list