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 vote123 views1 answer
SQL: calculate hours from two dates
SQL
1 vote123 views1 answer
"i_am_a_dummy flag" in MySQL
SQL
0 vote125 views1 answer
Select 1 from orders
SQL
0 vote119 views1 answer
Mysql match in serialized data
SQL
1 vote70 views1 answer
Python escape string for sql
SQL
0 vote115 views1 answer
Oracle sql winter time change
SQL
0 vote118 views1 answer
How to find symmetric pairs in sql
SQL
5 votes121 views1 answer
Oracle nls session
SQL
1 vote75 views1 answer
Mysql see column types
SQL
6 votes119 views6 answers
Count mysql
SQL