/SQL/Copy data from one table column to another table column in sql

Copy data from one table column to another table column in sql

Copy all values of a column to another column in sql in same table

UPDATE table SET columnB = columnA;

Source: stackoverflow.com

Copy data from one table column to another table column in sql

#to copy or update a table column from another table column 
UPDATE table_name1 
    SET column1 = (
        SELECT column2
        FROM table_name2
        WHERE table_name1.id = table_name2.id
    );

Sql query to copy data from one column to another

UPDATE table_name SET
    destination_column_name=orig_column_name
WHERE condition_if_necessary

Source: stackoverflow.com

Similar codes

2 votes207 views1 answer
Oracle sql query to make column data uppercase
SQL
-1 vote228 views8 answers
Create Trigger in phpMyAdmin
SQL
1 vote193 views3 answers
Remove unique key from a table
SQL
0 vote169 views1 answer
Hangfire clean script
SQL
1 vote219 views1 answer
Table information in sql server
SQL
13 votes218 views2 answers
Get date from now() mysql
SQL
3 votes219 views1 answer
Postgresql db owner change
SQL
0 vote234 views1 answer
Postgresql find biggest table
SQL
9 votes209 views3 answers
Where in sql
SQL
0 vote201 views1 answer
Como verificar registros duplicados no sql postgresql
SQL