/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 vote169 views1 answer
Postgresql add not null and not empty constraint
SQL
8 votes219 views1 answer
Mac restore mysql database command line
SQL
1 vote162 views2 answers
Mysql show views
SQL
0 vote188 views1 answer
Query to count the number of rows in a table in sqlalchemy
SQL
0 vote189 views1 answer
Default column value in sql same as another column laravel
SQL
15 votes178 views2 answers
How to know the username of postgresql
SQL
0 vote188 views1 answer
Sql server on mac m1
SQL
2 votes208 views1 answer
Select from array in psql
SQL
4 votes185 views1 answer
For loop postgresql
SQL
2 votes176 views3 answers
Sql truncate table
SQL