/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 vote352 views1 answer
Create table with primary key and foreign key in sql server
SQL
1 vote368 views2 answers
Full join
SQL
0 vote315 views1 answer
1 column values in to 1 single row in sql
SQL
0 vote391 views1 answer
Generate sql from specific migration ef core
SQL
-1 vote349 views1 answer
Default username and password for oracle 11g
SQL
0 vote369 views1 answer
Create-table-with-index-organization
SQL
5 votes323 views4 answers
Sql check
SQL
10 votes307 views1 answer
How to import database in mysql by cmd
SQL
0 vote329 views1 answer
Mysql dump everythign
SQL
0 vote308 views2 answers
Select limit ms sql
SQL