开发者

Add row that is duplicate except for one column

I need to write a query to add a duplicate row to a table a bit like this...

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

except that the first column must have a different value in the copied row.

i.e.

┌─────┬────────┬────────┐
|name | weight | height |
├─────┼────────┼────────┤
│ Bob │   100  │   150  │
│     │        │        │
└─────┴────────┴────────┘

To

开发者_开发百科┌─────┬────────┬────────┐
|name | weight | height |
├─────┼────────┼────────┤
│ Bob │   100  │   150  │
│ Jim │   100  │   150  │
└─────┴────────┴────────┘

I can't simply insert an identical row, and then update that column, because the "name" column is unique.

Obviously in reality my table has many more columns than this example.


Have you tried:

INSERT INTO `<table>` (column1, column2, ...)
SELECT 'Jim', column2, ... FROM ... WHERE ...
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜