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

5 votes186 views3 answers
Mysql remove unique constraint
SQL
1 vote180 views3 answers
Coderbyte mysql challenge MySQL challenge, your query should return the informatioi for the employee with the third highest salary.
SQL
16 votes176 views4 answers
Find duplicates mysql
SQL
0 vote175 views1 answer
Watch mysql command line
SQL
2 votes185 views1 answer
Mysql shell insert into
SQL
1 vote177 views2 answers
Pad zero sql server
SQL
5 votes171 views1 answer
Oracle scan source ddl
SQL
0 vote174 views1 answer
Count number of entires by months sql
SQL
0 vote166 views1 answer
Remove default constraint sql server
SQL
2 votes176 views1 answer
Sql server: select column values as comma separated string
SQL