/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

7 votes304 views1 answer
Mysql load data infile csv
SQL
0 vote337 views1 answer
Lost connection to MySQL server during query when dumping table
SQL
2 votes353 views1 answer
Can you use a where clause for a child query
SQL
0 vote330 views1 answer
Partitioning in oracle-base
SQL
0 vote346 views1 answer
Sql server select record with max id
SQL
0 vote314 views1 answer
Sql min
SQL
0 vote360 views1 answer
Mssql disable foreign key constraint
SQL
0 vote333 views1 answer
Oracle create package specification
SQL
0 vote321 views1 answer
Delete double on SQL with multiple primary keys
SQL
5 votes342 views1 answer
Sort order on two columns sql
SQL