/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

0 vote145 views1 answer
C# execute transact sql
SQL
0 vote134 views1 answer
Mysql query to check record exists in database table or not
SQL
13 votes142 views2 answers
Sql join
SQL
10 votes117 views3 answers
Join multiple tables sql
SQL
1 vote129 views1 answer
Postgresql convert text to float
SQL
2 votes136 views1 answer
Datetrunc
SQL
1 vote135 views1 answer
Mariadb alter user host
SQL
0 vote170 views1 answer
Client does not support authentication protocol requested by server sqlyog
SQL
13 votes131 views1 answer
Fetch first 5 rows in oracle sql developer
SQL
0 vote192 views1 answer
Tsql find procedure with name
SQL