/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 vote139 views1 answer
Oracle job schedules
SQL
11 votes121 views3 answers
How to get last row of table in sql
SQL
8 votes125 views1 answer
Oracle create datafile
SQL
3 votes139 views2 answers
Postgresql select all column names
SQL
0 vote134 views1 answer
Wordpress delete post revisions older than date "sql"
SQL
1 vote136 views1 answer
Mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists.
SQL
2 votes122 views1 answer
Q operator in plsql
SQL
0 vote188 views1 answer
How to get number of months between 2 dates sql server
SQL
-1 vote130 views1 answer
How to create foreign key in sql server management studio
SQL
14 votes123 views4 answers
Remove record from table sql
SQL