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 vote329 views1 answer
How to check which table has data in mysql
SQL
1 vote305 views1 answer
Oracle explain plan
SQL
12 votes309 views4 answers
Mysql version
SQL
5 votes328 views2 answers
Postgres update with if condition query
SQL
0 vote314 views1 answer
Postgresql default value boolean
SQL
12 votes302 views1 answer
How to change the value of a table in sql
SQL
2 votes276 views1 answer
Latest record in sql
SQL
0 vote340 views2 answers
Temp Space
SQL
0 vote308 views1 answer
Sql datediff month
SQL
14 votes329 views2 answers
Install mysqldump
SQL