/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

1 vote238 views1 answer
Cross schema query oracle 2 users
SQL
4 votes233 views1 answer
Refresh postgres config
SQL
0 vote240 views1 answer
Mysql query to select the highest value
SQL
1 vote252 views3 answers
Sql union
SQL
0 vote245 views1 answer
Change role postgres
SQL
0 vote223 views1 answer
When mysql server would not work in xampp
SQL
1 vote247 views1 answer
Trim leading zeros in sql
SQL
2 votes220 views1 answer
Drop table purge
SQL
1 vote226 views1 answer
Change table to innodb mysql
SQL
0 vote227 views1 answer
Error in connection_import_file(conn@ptr, name, value, sep, eol, skip) : RS_sqlite_import: test.csv line 2 expected 11 columns of data but found 1
SQL