Copy data from one table to another and change id [duplicate]

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-31 15:31:23Z

3

Try somethink like tis

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

edited Jan 31, 2018 at 15:31

answered Jan 31, 2018 at 15:11

Léo R.

2,7161 gold badge13 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

marc_s Over a year ago

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...

user330315 Over a year ago

"20" is an identifier (e.g. a column name) in SQL. I doubt there is a column named "20" in the work table

Léo R. Over a year ago

answer updated :)

Léo R. Over a year ago

i just tested my query, this work well

Martin54 Over a year ago

oh, I have used quotation marks in brackets.. tx :)

Random_User · Accepted Answer · 2018-01-31 15:11:42Z

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;

Collectives™ on Stack Overflow

Copy data from one table to another and change id [duplicate]

2 Answers 2

5 Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

Comments

Linked

Related