/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

3 votes216 views2 answers
How to start postgresql on windows
SQL
1 vote217 views1 answer
Sql server get users
SQL
1 vote242 views1 answer
How to select all attributes from a row if there is a certain string in it MySQL
SQL
8 votes218 views2 answers
Select table column name in sql
SQL
1 vote234 views1 answer
Postgresql where datetrunc month and year equal
SQL
15 votes215 views1 answer
Mysql int range
SQL
0 vote254 views2 answers
Remove mysql workbench ubuntu
SQL
12 votes221 views1 answer
Docker run mysql image
SQL
0 vote237 views1 answer
How to update date value in sql
SQL
1 vote222 views1 answer
List all triggers in SQL Server
SQL