How To Move 1 million Records from One table to Another Table?

Question

<p>Tables.</p>

Ibraheem Umar · Answer

One way is :

using SELECT INTO OUTFILE to put data in test.csv file :

SELECT * INTO OUTFILE 'test.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' FROM <table name>

Then Insert to new table :

LOAD DATA INFILE 'test.csv' INTO TABLE <tablename> FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' (column1,column2,column3)

Ghazanfar Shafiq · Answer

1. Use Import or export method

OR

2. Create table with same structure(design). Let say new table name is "table2" and first one from where you want to transfer is "table1". then use this query

insert into table2 select *from table1

Use this query

amar husain · Answer

alter table mytable add (newcolumn date); update mytable set newcolumn = oldcolumn; alter table mytable drop (oldcolumn);It's usually faster to disable the keys first, do the inserts, then enable the keys after insertion.

Uday Amineni · Answer

By using a VIEW we can move the data from ne table to another table that is data migration

Azam Mirzobekov · Answer

INSERT INTO `db`.`table_to`

SELECT *

FROM `db`.`table_from` ;

subhojit chaudhury · Answer

Create table with same structure(design). Let say new table name is "table2" and first one from where you want to transfer is "table1". then use this query

insert into table2 select *from table1

خدمات بيت.كوم

استخدم تطبيق بيت.كوم

ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

How To Move 1 million Records from One table to Another Table?

عمليات البحث الشائعة

المزيد من الأسئلة المماثلة