Mysql faster insert

CREATE TABLE copy LIKE original;

ALTER TABLE copy DISABLE KEYS;
SET unique_checks=0; SET foreign_key_checks=0; 

INSERT INTO copy SELECT * FROM original;

ALTER TABLE copy ENABLE KEYS;
SET unique_checks=1; SET foreign_key_checks=1;

-1

Source: stackoverflow.com

Similar codes

0 vote247 views1 answer
Postgresql in vs any performance
SQL
0 vote226 views1 answer
Postgresql find missing id
SQL
0 vote237 views1 answer
MySQL import data from large CSV file
SQL
0 vote235 views1 answer
Mysql group by range
SQL
0 vote223 views1 answer
Pl/sql loop example
SQL
1 vote245 views1 answer
How to delete data from sql database in android
SQL
0 vote233 views1 answer
Pl sql constraint user function
SQL
1 vote242 views1 answer
Md5 encryption for existing records
SQL
11 votes222 views2 answers
Having clause
SQL
0 vote278 views3 answers
Postgres trim string
SQL