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

1 vote332 views1 answer
Sql only five first row
SQL
0 vote336 views1 answer
Where case insensitive like mysql
SQL
2 votes358 views1 answer
Mysql sysdate - 1 day
SQL
0 vote385 views1 answer
Postgres duplicate database in same server while other session is using source database
SQL
1 vote341 views1 answer
Sql query row number group by
SQL
1 vote314 views1 answer
Sql auto timestamp
SQL
9 votes330 views6 answers
Sql insert into
SQL
3 votes344 views1 answer
Sql server check version
SQL
3 votes357 views1 answer
How to find names includes in sql
SQL
9 votes323 views4 answers
Mysql show table fields
SQL