Copy data from one table to another and change id

Question

I want to copy one row from one table to another table. But in the process I want change value of id. For example to 20. How to do it?

I have this code

INSERT INTO work_done
SELECT * FROM work_todo
WHERE id = 10

Léo R. · Accepted Answer · 2018-01-31T15:31:23.827

3

Try somethink like tis

INSERT INTO work_done
          ( id
          , col2
           ...
          )
     SELECT 20
          , col2
           ...
      FROM work_todo WHERE id = 10

edited Jan 31 '18 at 15:31

answered Jan 31 '18 at 15:11

Léo R.

2,620
1
10
22

1

Quite possibly, the values `10` and `20` are in fact **numerical** values and stored in a column of numerical type - so then they should **not** be put in double quotes in your query... – marc_s Jan 31 '18 at 15:20
`"20"` is an **identifier** (e.g. a column name) in SQL. I doubt there is a column named `"20"` in the work table – Jan 31 '18 at 15:23
answer updated :) – Léo R. Jan 31 '18 at 15:31
i just tested my query, this work well – Léo R. Jan 31 '18 at 15:35
oh, I have used quotation marks in brackets.. tx :) – Martin54 Jan 31 '18 at 15:54

score 0 · Answer 2 · answered Jan 31 '18 at 15:11

0

select *
 into work_done
 from work_todo
where id = 10;

update work_done a
   set a.id = 20;

OR

 select case id
            when id = 10
              then id = 20
     into work_done
     from work_todo
    where id = 10;

answered Jan 31 '18 at 15:11

Random_User

363
1
7

Copy data from one table to another and change id

2 Answers2