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 vote201 views1 answer
Sql xampp gabungan nama awal dan akhir
SQL
0 vote193 views1 answer
C# mysql data reader from two tables
SQL
1 vote207 views1 answer
Alter constraint in sql
SQL
4 votes207 views3 answers
Is not null sql
SQL
0 vote202 views1 answer
Check if string is a number sql
SQL
0 vote231 views1 answer
Virtuoso sql query tutorial
SQL
16 votes204 views4 answers
Mysql import from sql file
SQL
-3 votes187 views1 answer
Remove spaces sql 2008
SQL
14 votes218 views6 answers
Auto_increment mysql
SQL
1 vote205 views1 answer
Mysql select from outside
SQL