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>
> 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


More information about the PLUG mailing list