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 vote165 views1 answer
Get who is hired in specific month in sql
SQL
0 vote169 views1 answer
Sql make sure every user is unqiuew
SQL
7 votes177 views2 answers
Get database size mysql
SQL
0 vote296 views3 answers
Osx stop mysql service
SQL
2 votes233 views2 answers
Postgres set user as superuser
SQL
0 vote152 views1 answer
Deleted table in sql trigger
SQL
50 votes285 views6 answers
Sql count duplicate rows
SQL
0 vote186 views1 answer
Insert or update sql firebird
SQL
0 vote210 views1 answer
Mariadb change column type
SQL
0 vote203 views1 answer
Error code 1451 sql
SQL