Copy data from one mysql table to another mysql table of same database

Question

I have around 40 million rows in a MySQL table. I want to copy this table into another table of same database. What is the most efficient way to do this? How much time will it take (approx.)?

Sadikhasan · Accepted Answer · 2014-07-22 09:41:59Z

2

Try this

CREATE TABLE new_table LIKE old_table;
INSERT INTO new_table SELECT * FROM old_table;

answered Jul 22, 2014 at 9:41

Sadikhasan

18.6k23 gold badges85 silver badges126 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Nadendla · Accepted Answer · 2014-07-22 09:48:51Z

0

INSERT INTO table2(column1,column2,....) SELECT column1,column2,... FROM table1;

answered Jul 22, 2014 at 9:48

Nadendla

7222 gold badges7 silver badges18 bronze badges

Comments

Ashutosh SIngh · Accepted Answer · 2014-07-22 10:23:05Z

0

create table new_table as select * from Old_table;

when you copy data in this way all constraint are also copy in new table if you create table separate query and insert data through separate query constraint are not copied in new table

answered Jul 22, 2014 at 10:23

Ashutosh SIngh

1,0193 gold badges17 silver badges28 bronze badges

Collectives™ on Stack Overflow

Copy data from one mysql table to another mysql table of same database

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related