Is there a standard way to duplicate a row in a database table?

Question

I want to duplicate a row, not the keys of course, without explicity using the field names. Is there a SQL way or do I have to enumerate the field names through code? I don't want to explicity use field names because I want to minimize code and db dependencies. I am going to use it in the Ms Access 2003. I mention it in case that no standard way exists.

Accepted Answer

```
INSERT INTO `<table>` (column1, column2, ...) -- Not IDENTITY columns
SELECT column1, column2, ... FROM ...
```

This will also allow you to insert replacement values for the primary key columns, etc. I've used this, along with a common table expression, to take a set of test data from the month of February, and to pretend they're really from June.

I know you said you want to do it without the field names, but I don't think you can. It's also not a good idea, as it would tie you to the order of the columns.

Is there a standard way to duplicate a row in a database table?

Solution

Problem