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