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 vote191 views2 answers
Timing sql queries
SQL
37 votes179 views3 answers
Postgresql insert column
SQL
0 vote143 views0 answer
SQL
0 vote181 views2 answers
Sql last updated
SQL
0 vote206 views1 answer
Sql query inline if
SQL
11 votes283 views5 answers
Update table from another table mysql
SQL
0 vote210 views1 answer
Mysql best varchar length size
SQL
2 votes261 views1 answer
Sql missing records from another table
SQL
10 votes187 views2 answers
Mysql drop database if exists
SQL
0 vote198 views1 answer
Drop specific row postgresql
SQL