In SQLite how do I copy data from one column to another in the same database table?
Try this:
UPDATE tableName SET destinationField = sourceField