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

24 votes237 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
SQL
1 vote316 views2 answers
Install sql server management studio ubuntu
SQL
22 votes290 views4 answers
Mysql date_format
SQL
0 vote262 views1 answer
Default column value in sql same as other column
SQL
0 vote259 views1 answer
Postgresql copy backup table
SQL
3 votes254 views1 answer
Sql cast to integer
SQL
0 vote270 views1 answer
Sql query for displaying age from oldest to youngest
SQL
1 vote220 views1 answer
Postgres reset auto increment
SQL
1 vote277 views2 answers
ImportError: No module named mysql.connector
SQL
0 vote287 views1 answer
How to get parent and child record in single query using sql
SQL