Answers for "how to copy data from one table to another table in sql"

insert a select statement into a table

--format
INSERT INTO Customers (CustomerName, City, Country)
SELECT SupplierName, City, Country FROM Suppliers;

--examples
INSERT INTO Customers (CustomerName, City, Country)
SELECT SupplierName, City, Country FROM Suppliers;

Posted by: Guest on March-30-2020

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
    );

Posted by: Guest on October-23-2021

Code answers related to "how to copy data from one table to another table in sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "how to copy data from one table to another table in sql"

Code answers related to "how to copy data from one table to another table in sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "how to copy data from one table to another table in sql"

Code answers related to "how to copy data from one table to another table in sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us