Thread: all columns but one

all columns but one

From
"Vladimir V. Zolotych"
Date:
  Hello all,
Happy New Year!

Does anybody know is it possible to tell
"all columns but one" in sentences like the following:

insert into bar (b,c,d,e,f,g,h) select (b, c,d,e,f,g,h) from foo;

where foo, bar contains the same set of columns just as mentioned
above plus column a, e.g. the full set of columns is: a,b,c,d,e,f,g,h

Thanks!

--
Vladimir Zolotych                         gsmith@eurocom.od.ua

Attachment