Copy data from one column to other column (which is in a different table)

by

Here the query:

Same Table:

UPDATE table_name 
SET column1 = column2

Different Table:

UPDATE table_name1 
    SET column1 = (
        SELECT column2
        FROM table_name2
        WHERE table_name1.id = table_name2.id
    );

More Related Contents:

  1. What is the difference between UNION and UNION ALL?
  2. How can I do an UPDATE statement with JOIN in SQL Server?
  3. Recommended SQL database design for tags or tagging [closed]
  4. Select First Row of Every Group in sql [duplicate]
  5. Why does NULL = NULL evaluate to false in SQL server
  6. The multi-part identifier could not be bound
  7. must appear in the GROUP BY clause or be used in an aggregate function
  8. How to insert a line break in a SQL Server VARCHAR/NVARCHAR string
  9. MySQL number of items within “in clause”
  10. GROUP BY / aggregate function confusion in SQL
  11. Possible to perform cross-database queries with PostgreSQL?
  12. Mixing implicit and explicit JOINs
  13. Fastest way to update 120 Million records
  14. Calendar Table – Week number of month
  15. how can I Update top 100 records in sql server
  16. What’s the proper index for querying structures in arrays in Postgres jsonb?
  17. How can I have NHibernate only generate the SQL without executing it?
  18. get next sequence value from database using hibernate
  19. Selecting Random Rows in MySQL
  20. concatenate two database columns into one resultset column
  21. SQLite and custom order by
  22. Update a table with join?
  23. How can I compare time in SQL Server?
  24. Is there any way to flush output from PL/SQL in Oracle?
  25. Combine two columns and add into one new column
  26. SQL: capitalize first letter only [duplicate]
  27. SQL: Two select statements in one query
  28. How to execute a stored procedure inside a select query
  29. SQL Inner Join On Null Values
  30. PostgreSQL: Full Text Search – How to search partial words?

Leave a Comment