I knew it had to be something REAL simple! :-)
Thanks guys, that worked perfectly!
Ananda Kumar wrote:
>
> u want something like this
>
> INSERT INTO table1 (field2, field3, field4) SELECT field2, field3, 'abcd'
> from table_name
> WHERE field2=x
>
&g
Hi!
I have a table with several rows, some of which I need to duplicate.
The fields of table1 are field1, field2, field3 and field4. Field1 is
automatically incremented,
field2 will serve as a filter condition.
Normally to duplicate the rows that matched a certain condition I would do:
INSERT