How to copy data from one table to another new table in MySQL

Question

I want to copy data from one table to another in MySQL   Table 1  Existing table    aid     st id from uid to gid to uid created changed subject message link   Table 2  New Table   st id uid changed status assign status   I want to copy some fields of data from TABLE 1 into TABLE 2   Can this be done using MySQL queries

User · Answer

You can easily get data from another table. You have to add fields only you want.

The mysql query is:

INSERT INTO table_name1(fields you want)
  SELECT fields you want FROM table_name2

where, the values are copied from table2 to table1

User · Answer

CREATE TABLE newTable LIKE oldTable    Then  to copy the data over  INSERT INTO newTable SELECT   FROM oldTable

User · Answer

You should create table2 first    insert into table2 field1 field2      select field1 field2      from table1 where condition

User · Answer

You can try this code  insert into  temp  select Product ID Max Grand Total  AS  Sales Amt   Max Rec Amount         from Table Name group by Id

User · Answer

IF the table is existed  you can try  insert into table name select   from old tale   IF the table is not existed  you should try  create table table name like old table  insert into table name select   from old tale

User · Answer

If you don t want to list the fields  and the structure of the tables is the same  you can do   INSERT INTO  table2  SELECT   FROM  table1     or if you want to create a new table with the same structure   CREATE TABLE new tbl  AS  SELECT   FROM orig tbl    Reference for insert select   Reference for create table select

User · Answer

The best option is to use INSERT   SELECT statement in mysql   http   dev mysql com doc refman 5 0 en insert-select html

User · Answer

SELECT   INTO newtable  IN externaldb  FROM table1    http   www w3schools com sql sql select into asp

User · Answer

INSERT INTO Table1 Column1 Column2    SELECT Column1 Column2   FROM Table2  WHERE  lt condition gt

User · Answer

This will do what you want   INSERT INTO table2  st id uid changed status assign status  SELECT st id from uid now    Pending   Assigned  FROM table1   If you want to include all rows from table1  Otherwise you can add a WHERE statement to the end if you want to add only a subset of table1   I hope this helps

User · Answer

the above query only works if we have created clients table with matching columns of the customer  INSERT INTO clients c id name address SELECT c id name address FROM customer

[mysql] How to copy data from one table to another new table in MySQL?

Examples related to mysql

Examples related to copy