| Subject | Re: [firebird-support] Insert from query, but changing one field? |
|---|---|
| Author | Joe Martinez |
| Post date | 2003-10-22T06:08:49Z |
>Assuming you have a generator + trigger supplying the PK value, col1:No, I don't have a generator/trigger generating the PK.
>
>insert into enrollments (col2, col3, ...., classid, ....)
>select col2, col3, ...., 456, ....
>from enrollments
>where classid <> 456
-Joe