sql question

Dennis devel at muhlesteins.com
Tue Jul 12 16:28:35 MDT 2005


Merrill Oveson wrote:

>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?
>  
>
You could create a view that selects the columns you want.  Then you can
"select * from the_view".  There isn't an SQL way to exclude some in any
of the DBs I know about though.

>I'm using sqlserver and mysql
>.=================================.
>| This has been a P.L.U.G. mailing. |
>|      Don't Fear the Penguin.      |
>|  IRC: #utah at irc.freenode.net   |
>`================================='
>  
>




More information about the PLUG mailing list