Search
Search

How do i copy data from one table to another table?

dats Published at Dev
16
dats

I have 2 tables, country and division with the ff schemas:

country               division
-----------           ------------
countrycode           divisioncode
contryname           countrycode
                      divisionname

I want to copy data from the country table into the division table where countrycode goes into divisioncode and countrycode in division table and countryname going into divisionname

For ex, US - United States goes into the division table as US, US, United States.

Ullas

Use INSERT INTO ... SELECT

Query

INSERT INTO division(divisioncode, countrycode, divisionname)
SELECT countrycode, countrycode, countryname
FROM country;

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

From Java

How do I copy data from one table to another in postgres using copy command

From Dev

Copy Data from one hbase table to another

From Dev

How can I copy one column to from one table to another in SQL Server

From Dev

How to copy data from one table to another where column data types are different?

From Dev

How do I select items from one table such that a query in another table yields exactly one row?

From Dev

Copy a table with data from one MySQL server to another

From Dev

copy data from one table to another table in another database

From Dev

How do I copy data from each record of one table into multiple records of another table related to the first table?

From Dev

How to copy data from one table into another in Microsoft SQL Server

From Dev

How copy data from one table into another? PHP

From Dev

How do I copy a date from one variable to another in R data.table without losing the date format?

From Dev

How to copy data from one database/table to another Remote one by it's Ip

From Dev

How to copy rows from one table to another?

From Dev

Copy table data from one database to another

From Dev

MYSQL, copy data from one table to another table with increment in varchar

From Dev

How do I get data from another table in MySQL?

From Dev

More Efficient Way to Copy Large Data from One Table to Another

From Dev

Copy Data from one hbase table to another

From Dev

How do I select items from one table such that a query in another table yields exactly one row?

From Dev

copy table data from one db to another with where condition

From Dev

How copy data from one table into another? PHP

From Dev

How do i copy data from one table to another table?

From Dev

Copy table data from one database to another

From Dev

Copy Data from one table to another table

From Dev

Can i copy data from one database table to another already existing database table sql server?

From Dev

How to separate column data to copy from one table to other table?

From Dev

How do I copy data from one column in table A to table B in Oracle

From Dev

how to copy only data from one database table to another database existing table in sql server

From Dev

How do I populate a row with data from another table?

Related Related

  1. 1

    How do I copy data from one table to another in postgres using copy command

  2. 2

    Copy Data from one hbase table to another

  3. 3

    How can I copy one column to from one table to another in SQL Server

  4. 4

    How to copy data from one table to another where column data types are different?

  5. 5

    How do I select items from one table such that a query in another table yields exactly one row?

  6. 6

    Copy a table with data from one MySQL server to another

  7. 7

    copy data from one table to another table in another database

  8. 8

    How do I copy data from each record of one table into multiple records of another table related to the first table?

  9. 9

    How to copy data from one table into another in Microsoft SQL Server

  10. 10

    How copy data from one table into another? PHP

  11. 11

    How do I copy a date from one variable to another in R data.table without losing the date format?

  12. 12

    How to copy data from one database/table to another Remote one by it's Ip

  13. 13

    How to copy rows from one table to another?

  14. 14

    Copy table data from one database to another

  15. 15

    MYSQL, copy data from one table to another table with increment in varchar

  16. 16

    How do I get data from another table in MySQL?

  17. 17

    More Efficient Way to Copy Large Data from One Table to Another

  18. 18

    Copy Data from one hbase table to another

  19. 19

    How do I select items from one table such that a query in another table yields exactly one row?

  20. 20

    copy table data from one db to another with where condition

  21. 21

    How copy data from one table into another? PHP

  22. 22

    How do i copy data from one table to another table?

  23. 23

    Copy table data from one database to another

  24. 24

    Copy Data from one table to another table

  25. 25

    Can i copy data from one database table to another already existing database table sql server?

  26. 26

    How to separate column data to copy from one table to other table?

  27. 27

    How do I copy data from one column in table A to table B in Oracle

  28. 28

    how to copy only data from one database table to another database existing table in sql server

  29. 29

    How do I populate a row with data from another table?

HotTag

Archive