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 vote292 views3 answers
How to increase size of column in sql
SQL
-1 vote274 views1 answer
How to switch user in mysql
SQL
4 votes287 views4 answers
Start mysql
SQL
6 votes270 views1 answer
Check Table Exists
SQL
-1 vote291 views1 answer
Failed to process SQL command - ORA-28014: cannot drop administrative user or role
SQL
0 vote281 views1 answer
Selecting all columns from table sql database
SQL
5 votes275 views1 answer
Oracle get foreign keys on table
SQL
-1 vote281 views3 answers
SQL MM/dd/yyyy format
SQL
2 votes291 views2 answers
How to add not null constraint in sql
SQL
2 votes251 views1 answer
Sql find missing values between two tables
SQL