Duplicate Records Wanted!

[KariAnn0]

Ok, I have a large table.

In this large table I want to make a copy of all the records and make duplicates of every field except for the primiary key, which would be different and another field which would be different.
I would be setting this other different field to say '4'.

Is there a way to do this without having to go through each record grabbing the information and inserting each one individually?

Thanks

[cvsherri]

insert into table (nonIdcol1, nonIdcol2 ,nonIdcol3)
SELECT nonIdcol1, nonIdcol2 ,nonIdcol3 FROM table

That just worked for me 🙂

[cvsherri]

and this will allow you to change one field

insert into table (nonIdcol1, nonIdcol2 ,nonIdcol3)
SELECT nonIdcol1, nonIdcol2 ,'4' FROM table