Repeating a row in a table

[zonkd]

I want to duplicate a row in a table.

I thought that

UPDATE table1 SET id '1' = id '2';

might do it, but it doesn't. Help, please, experts ...

[swampBoogie]

I don't understand what you are trying to accomplish. Give some sample data that describes the contents before and after the operation.

[r937]

INSERT
  INTO table1
     ( id
     , somecol )
SELECT 5
     , somecol
  FROM table1
 WHERE id = 4

does your table have id as the primary key?

[zonkd]

Thanks, r937, you helped enormously elsewhere. I would have been back sooner, only there weren't any email notices.