How do I copy data from one column to another in the same table?

Question

In SQLite how do I copy data from one column to another in the same database table?

Henry Twist · Accepted Answer · 2021-03-11 00:24:24Z

64

Try this:

UPDATE tableName SET destinationField = sourceField

edited Mar 11, 2021 at 0:24

Henry Twist

6,0723 gold badges21 silver badges51 bronze badges

answered Jan 29, 2011 at 13:21

Vladimir Ivanov

43.2k19 gold badges80 silver badges103 bronze badges

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

2 Comments

Mike 'Pomax' Kamermans Over a year ago

What if that results in foreign key mismatch - "someOtherTable" referencing "tableName": UPDATE tableName SET destinationField = sourceField? (where someOtherTable references the source field, which we're not touching).

ozcanyarimdunya Over a year ago

This sql may require where clause, so just add where 1=1 at the end of script!

Collectives™ on Stack Overflow

How do I copy data from one column to another in the same table?

1 Answer 1

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Related