/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

10 votes164 views1 answer
Oracle dependency
SQL
0 vote181 views1 answer
Mariadb maximum left join
SQL
1 vote214 views2 answers
Install sql server management studio ubuntu
SQL
0 vote165 views3 answers
Create and attach user to a postgresql database
SQL
1 vote180 views2 answers
Sql for date greater than
SQL
0 vote179 views1 answer
Change magento database url usimg musql
SQL
0 vote174 views1 answer
How to write triggers to increment or decrement the number of employees
SQL
0 vote192 views1 answer
Compare subqueries oracle
SQL
2 votes176 views1 answer
Copy all values of a column to another column in sql in same table
SQL
5 votes179 views6 answers
Sql foreign key
SQL